When deploying my application that uses sql server it doesn't connect to the server.
I checked the connection string & it's ok the server instance is the same.
The computer name isn't the same & i use the .\SQLExpress as the data source.
I get an error saying 'sqlserver does not allow remote connections error 26 locating server / instance specified'.
Since computer name is changed, can you try to recreate the data source again? When creating a datasource, you can verify that if the datasource is ok to connect to the server.|||Another thing to look at is that if computer name is changed, the servername might not be valid. Can you run select @.@.servername to verify?|||This link can help you.
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
|||The connection string from the dataset that visual studio generated was wrong
it needed to be .\SQLExpress thanks to all for the help
No comments:
Post a Comment