hi all
When I use asp.net 2.1 to connect sql 2005 express locally I got error message to say
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.
(provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
I use following connection string
ConnectToDb.ConnectionString = "Data Source=servername;InitialCatalog=PushToMail;Integrated Security=true";
for more information : when I open SQLEXPRESS this oblige me to inter
servername : servername\sqlexpress
authentification: windowsauthentification
and when i try this connection
ConnectToDb.ConnectionString = "Data Source=servername\sqlexpress;InitialCatalog=PushToMail;Integrated
Security=true";
l got this erreur "inorganised sequence space"
next time u install sql 2005 ,use both authentication ,windows and sql.
or try to connect sql using your VS 2005 ,if u have.
|||Read this thread,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327846&SiteID=1
It has answer that explains how to enable remote connections.
No comments:
Post a Comment