Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Prifiler Error

Author  Topic 

sqlnaveen
Starting Member

1 Post

Posted - 2009-02-09 : 20:09:50
Hi I am trying to see some trace in Sql Profiler

I have access to two servers one is Server 1 and 2
I can able to connect to my server 1 with the Windows Authontication
and when i am trying to connect my server 2 its giving some error message. like this.

error:-
===================================

Cannot connect to SGSGADB61.

===================================

Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
SQL Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF].
(pfutil90)

------------------------------
Program Location:

at CProfilerSqlDbConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

Naveen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-09 : 20:11:51
Add an alias to Server1 so that it knows how to connect to Server2. The alias would probably be Server2,PortNumber.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

the1mavin
Starting Member

1 Post

Posted - 2009-02-11 : 12:46:47
Hi Tara,

We are seeing the same error trying to set up a Cube for Project Server on a multi-node cluster.

Can you please explain what you mean by setting up an alias?

Thank you,
Tim
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-11 : 14:36:09
You can setup aliases in SQL Server Configuration Manager.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -