March 19, 2008 at 10:56 am
I found a problem that is proving quite hard to solve. Instead of connecting to an slq 2005 express server, I want to connect to my MSSQLSERVER when i'm configuring the ASP.NET Quickstart Tutorials
I have enabled remote connections in the SQLSERVER service and opened all combinations of pipe, tcp/ip and shared memory, even though I am connection to a local database.
I installed the asp.net quickstart tutorials changing the default instance of sql server .\sqlexpress to .\mssqlserver
when i tried to see the the data in the GridView (http://localhost/QuickStartv20/aspnet/samples/data/GridViewSimple_vb.aspx), i got this error:
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 have changed the data source from .\SQLExpress to .\MSSQLSERVER. I am using windows authentication to connect to the database.
please help me !
Marc
March 19, 2008 at 7:57 pm
Unless you setup a named instance change ".\MSSQLSERVER" to "." or your computername.
By default, SQL Server express installs a named instance which is why it's specified that way in the examples; computername\SQLExpress.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply