Hi all,
I'm having a little trouble connecting to a SQLExpress instance on a remote domain using SQL Server Management Studio Express.
I've read that by default the program is set up locally only, so have edited the Surface Area Configuration. It only gives me the option to edit 'Services and Connections' on the localhost, but have edited the Remote Connections to use TCP/IP and Named Pipes.
In the Management Studio, I enter the server name, and login credentials. On the Connection Properties tab I changed the network protocol to TCP/IP though everytime I attempt to connect I get the following error message:
Any help would be greatly appreciated.
Rich
Hello,
Does this help you?http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Regards,
Louis
|||Hmm, I followed the steps through, the only difference seemed the firewall exceptions which I have now edited, but still get the same error message.
Any ideas?
|||from the client machine, can you ping the database server? Can you log the denial on the sql server box when you connect to it?
|||How would I go about doing this?
Cheers
No comments:
Post a Comment