I am trying to login into sql express using studio express and keep getting this msg.
"Cannot connect
....... under the default setting SQL Server does not allow remote connections. (provider: Named Popes Provider, error: 40 - could not open a connection to sql server) (sql server error2)"
I did try and make a change under surface area configuration to include local and remote connections but it did not help. Any thoughts? Thanks!
David
Are you using the SQL Server Browser service ? If not it could that that you might not use the default port of 1433. If so, type in the port number after the InstanceName using the syntax Servername\InstanceName,PortNumber which should be in your case something more specific Servername\SQLExpress,PortNumber
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment