No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
Jason
I figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No entries show up in SQL Server Profiler trace

Hi,
I have inherited a SQL Server 2000 machine with 59 databases on it,
several of which I suspect are no longer used.
I am setting up a SQL Profiler trace to show me which databases are
still being accessed, and by which machine/user.
There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
7, 2000 and 2005.
The problem I'm encountering is this:
I start the Profiler trace on SQL Server machine A
>From my local machine's Query Analyzer, I then query a table in one of
the suspect databases on machine A, via a linked server entry in my
local SQL Server instance
None of this query activity against the database is logged in Profiler
on machine A
What am I missing?
Thanks in advance-
JasonI figured it out. I am now monitoring the event class "Security
Audit->Audit Object Persmission Event", and bringing back the data
columns ObjectName, LoginName, and Hostname to know what's being looked
at, by whom, and from what machine.
JasonReber@.gmail.com wrote:
> Hi,
> I have inherited a SQL Server 2000 machine with 59 databases on it,
> several of which I suspect are no longer used.
> I am setting up a SQL Profiler trace to show me which databases are
> still being accessed, and by which machine/user.
> There are 4 other SQL Servers in use here, too, running SQL Server 6.5,
> 7, 2000 and 2005.
> The problem I'm encountering is this:
> I start the Profiler trace on SQL Server machine A
> >From my local machine's Query Analyzer, I then query a table in one of
> the suspect databases on machine A, via a linked server entry in my
> local SQL Server instance
> None of this query activity against the database is logged in Profiler
> on machine A
> What am I missing?
> Thanks in advance-
> Jason

No Email

Hello.
I have created a domain account, granted the account Administrator access on
the report server machine, have changed the two windows services to run as
that account, and have created an Exchange mailbox for the domain account.
I created a simple report that has no data source. I created a shared
calendar that runs every 1 minute. I subscribed to the report on that
schedule, no report.
The report is not being emailed.
Any thoughts?
Thanks in advance,
MikeAlso, SQL server instance is on a different machine.
I don't think that the report is even running. Does reporting services use
the SQL agent?
"mike" <milop@.slomins.com> wrote in message
news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have created a domain account, granted the account Administrator access
> on the report server machine, have changed the two windows services to run
> as that account, and have created an Exchange mailbox for the domain
> account.
> I created a simple report that has no data source. I created a shared
> calendar that runs every 1 minute. I subscribed to the report on that
> schedule, no report.
> The report is not being emailed.
> Any thoughts?
> Thanks in advance,
> Mike
>|||No,Mike it does not.
"mike" wrote:
> Also, SQL server instance is on a different machine.
> I don't think that the report is even running. Does reporting services use
> the SQL agent?
> "mike" <milop@.slomins.com> wrote in message
> news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > Hello.
> >
> > I have created a domain account, granted the account Administrator access
> > on the report server machine, have changed the two windows services to run
> > as that account, and have created an Exchange mailbox for the domain
> > account.
> >
> > I created a simple report that has no data source. I created a shared
> > calendar that runs every 1 minute. I subscribed to the report on that
> > schedule, no report.
> >
> > The report is not being emailed.
> >
> > Any thoughts?
> >
> > Thanks in advance,
> >
> > Mike
> >
>
>|||As Per my knowledge an SQL Agent job is created for each schedule. SQL Server
Agent is very much required to run the Scheduled SRS Reports.
Ashish
"ProJester" wrote:
> No,Mike it does not.
>
> "mike" wrote:
> > Also, SQL server instance is on a different machine.
> >
> > I don't think that the report is even running. Does reporting services use
> > the SQL agent?
> >
> > "mike" <milop@.slomins.com> wrote in message
> > news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > > Hello.
> > >
> > > I have created a domain account, granted the account Administrator access
> > > on the report server machine, have changed the two windows services to run
> > > as that account, and have created an Exchange mailbox for the domain
> > > account.
> > >
> > > I created a simple report that has no data source. I created a shared
> > > calendar that runs every 1 minute. I subscribed to the report on that
> > > schedule, no report.
> > >
> > > The report is not being emailed.
> > >
> > > Any thoughts?
> > >
> > > Thanks in advance,
> > >
> > > Mike
> > >
> >
> >
> >sql

No data is displayed in a Report on Win98

Hi,

I have created an OCX control in VB6.0 that contains the crystal report viewer.

On development machine (i.e. Win2K), my OCX control shows the crystal report properly. But, when I install my application on the client machine (Win98) no data is displayed in the report.

I have created the report using ADO connection and I am using 'SetDataSource' method of report object to pass the recordset to the report.

I have installed Crystal Report Application on the client machine. Through crystal report application I could see the data in the report.

Can any one help me?

With regards,
PinakinI use CrystalRyport. I want to print records in the same line in succession, how do i do

No data found when I browse cube

Hi,I have MS SQL Server (& Analysis Server) installed on a Windows 2000 server machine.I installed the MS SQL Server client and Analysis server on my local machine too(Windows NT).Now,I created an Analysis database on my local machine whose data source lies on the Windows 2000 server machine.When I access the cube data from my local m/c,I can see the data.
Then,I took the backup of my local Analysis database(.CAB) and restored it onto the Windows 2000 server machine.But now,when I try to browse the cube data on the Windows 2000 server machine,I don't find any data!!
I don't have to clue about what went wrong.I have installed SP3 on both the machinessql

No connection could be made because the target machine actively refused it

Hi,

I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown.

No connection could be made because the target machine actively refused it

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SocketException (0x274d): No connection could be made because the target machine actively refused it]

System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +307

System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +24

System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port) +81

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +208

[AdomdConnectionException: A connection cannot be made. Ensure that the server is running.]

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +384

Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +51

Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +398

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla() +124

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) +144

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +601

cubicdimension.Reportdisp.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\cubicdimension\Reportdisp.aspx.vb:65

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

May I mention here, that the computer where I tried deploying, has SQL Server 2000 as well as SQL Server 2005. I tried reinstalling MSXML, but the computer already has a higher version of MSXML.

Any help in this regard would be appreciated.

Best Wishes.

Check Programs/SQL Server 2005/ Configuration tools/SQL Server Surface Area Configuration.

In "Surface Area Configuration for services and connection", you click on the service and remote connections.

See that you have local and remote connections activated.

HTH

Thomas Ivarsson

No connection could be made because the target machine actively refused it

Hello,

I am not sure if this is the right forum.

This is the first time that I have seen this error,

No connection could be made because the target machine actively refused it

I have a web app that when some one inserts text in a text box and clicks a button it creates a new web page and a new table in the database. Up until this point it has always worked. A datalist returns the data. In the datalist there is a hyperlink that when clicked takes the client to the new webpage. But for some reason it is not working now and that is the error above.

I am lost. Any help appreciated.

Thanks Matt

I figured it out.

Thanks

Matt

No connection

Hello,

New development machine with Sql Server Express and Visual Web Developer.

I created a database then tried to connect from a test page on localhost and it worked. Then I tried from the internet domain and could not. So under the

Surface Area Configuration, I change the Remote Connections to Using both TCP/IP and named pipes and restarted the Database Engine. But

I still could not connect. So I restarted the machine. Now I can't view the page on localhost either. I can view a different web page so the Web server is

working.

I get the following as the exception:Error reading the database: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

My connection string is: "Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDBFilename=|DataDirectory|Externalresearch.mdf;User Instance=True"

Any suggestions?

Okay I found out why. If I have Web Developer open (with the database connection open) I cannot connect from the browser. But

if I close Web Developer then I can connect from the browser (ie, view my test page).

Is this because it's the same machine that I am both viewing the web page and hosting Sql server (ie, the user can only be used once)?

|||

Hi,

It's a little strange that it says you're using the Network Service to connect to SQL Server.

Are you connecting to the SQL Server through Internet with the windows authentication? If so, that's not supported, since the windows identity cannot be passed through internet.

|||

Kevin,

Everything including the database is on one machine. I'm using Windows authentication. So when I'm in Visual developer and connect

to the database, my web page (again hosted on the same machine) cannot connect to the database. It's a new installation of everything

with defaults setup. How can I work on the database while my web pages can still access the database? I just downloaded Managament

Studio Express, will this do?

Thanks for any help

|||

Hi,

Yes, you can use Management Studio to grant database access permission to the Network Service account.

By default, it does not have permission to the SQL Server. After granting the access, it will be working fine, I think.

sql

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server for
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reported
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
I was able to fix the problem. ADE Connection "Data Link Properties" accepts
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access ADE
> project and it complains that it is not able to connect to (local) server for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" reported
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server fo
r
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reporte
d
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>I was able to fix the problem. ADE Connection "Data Link Properties" accept
s
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access AD
E
> project and it complains that it is not able to connect to (local) server
for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" repor
ted
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

Newbie: SQL Server connection, help needed

Needs some help, I recently recieved an evaluation copy of SQL Server2000
and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
Server to
service pack3 and installed .net as well. I am still having connection
problems. I am
trying to setup an ODBC connection from another XP and win2000 machines.
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'rick'. Reason: Not associated with a trusted SQL Server connection.
I have already checked for Windows Authentication being enabled on the
server.
Of course the ODBC connection works locally.
'preciate any help
thanks
Hi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rick" <rmsingh@.rogers.com> wrote in message
news:eHqmDTdEFHA.392@.TK2MSFTNGP14.phx.gbl...
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
> 'preciate any help
> thanks
>

Newbie: SQL Server connection, help needed

Needs some help, I recently recieved an evaluation copy of SQL Server2000
and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
Server to
service pack3 and installed .net as well. I am still having connection
problems. I am
trying to setup an ODBC connection from another XP and win2000 machines.
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'rick'. Reason: Not associated with a trusted SQL Server connection.
I have already checked for Windows Authentication being enabled on the
server.
Of course the ODBC connection works locally.
'preciate any help
thanksHi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rick" <rmsingh@.rogers.com> wrote in message
news:eHqmDTdEFHA.392@.TK2MSFTNGP14.phx.gbl...
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
> 'preciate any help
> thanks
>