I'm getting the same error message (The user instance login flag is not supported on this version of SQL Server. The connection will be closed), except it's from trying to run/access the Club web site starter kit from my localhost & local SQL Server
2005.
I have the LocalSqlServer connection string. I have the <remove name="LocalSqlServer" />. I have manually created my Club database. I've ran the aspnet_regsql.exe against my database.
That stored procedure is part of the ASP.NET v2.0 framework. To install that, run aspnet_regsql which is in your framework folder. It has a GUI so just double click and follow the prompts. That will install the .NET schema in your database which will solve
this particular issue.
Hi,
Ran the .exe
Now there is a new Db in sql 2005 called aspnetdb. I can see the missing SP now.
In the web.config of the timetracker I am pointing it to TimeTracker database. Is this ok?
And I am still getting the same error as before (i.e. dbo.aspnet_checksumversion sp is missing).
May be I should change the connectionstring of name="LocalSqlServer"
to be pointing to this new DB (i.e
aspnetdb)
And the connectionstring of name="aspnet_staterKits_TimeTracker" to be pointing to TimeTracker
database
Yep, looks like you're on the right track. I assume that the timetracker was developed so that the ASP.NET schema is controlled by the LocalSqlServerconnection string (by default). This allows you to have them both in the same database or have them separated.
Hi,
I have SQL Server 2005 Developer Edition installed as an instance (computername\SQLServer2005) as the default one is SQL Server 2000. Now i changed the web.config as follows: connectionString="Data
Source=.\SQLServer2005;
This solved an 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: 26 - Error Locating Server/Instance Specified) .
Then when i start the Time Tracker project I get error:
Exception Details: System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
On one of the forum posting it mentioned to run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe (Not sure why, something about allowing SQL Server 2005 to create database from an ASP.net app which it doesn't support
unlike SQL Express). Anyway after runnign it a new DB was created in my SQL Server 2005 instance - aspnetdb. As part of the creation i choose Windows integration since i have mixed mode support in my DB (so Windows Authentication works when i use SQL Management
STudio) and i figured it should work here. But when i start the Time Tracker app in Visual Web Developer 2005 Express Edition it still causes the error
Exception Details: System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
I don't even see the timetracker database as being created in SQL 2005. When i had tested this app with SQL Express on another machine it created this DB in SQL Express. But i cannot get it to do the same for this SQL Server 2005 Developer Edition instance.
Any suggestions would be appreciated.
P.S.: As you notice I'm a complete novice in programming and maybe intermediate in SQL Server so please give detailed steps if possible
BugInfested
Member
420 Points
107 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 07, 2005 06:22 AM|LINK
Scott,
I'm getting the same error message (The user instance login flag is not supported on this version of SQL Server. The connection will be closed), except it's from trying to run/access the Club web site starter kit from my localhost & local SQL Server 2005.
I have the LocalSqlServer connection string. I have the <remove name="LocalSqlServer" />. I have manually created my Club database. I've ran the aspnet_regsql.exe against my database.
However, I'm still getting that error message.
Any suggestions?
fmardani
Participant
1377 Points
303 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 29, 2005 10:19 AM|LINK
Hi,
I had the same problem and now it seems that I can connect (Had to change the webconfig.)
The error now is:
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
This SP can not be found in .sql that came with the download.
Any thoughts please?
Thanks
OWScott
Participant
1939 Points
360 Posts
ASPInsiders
MVP
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 29, 2005 02:51 PM|LINK
Scott
Microsoft MVP - IIS
Vaasnet
www.vaasnet.com
fmardani
Participant
1377 Points
303 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 29, 2005 04:29 PM|LINK
Thanks
OWScott
Participant
1939 Points
360 Posts
ASPInsiders
MVP
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 29, 2005 05:17 PM|LINK
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Scott
Microsoft MVP - IIS
Vaasnet
www.vaasnet.com
fmardani
Participant
1377 Points
303 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 29, 2005 08:11 PM|LINK
Hi,
Ran the .exe
Now there is a new Db in sql 2005 called aspnetdb. I can see the missing SP now.
In the web.config of the timetracker I am pointing it to TimeTracker database. Is this ok?
And I am still getting the same error as before (i.e. dbo.aspnet_checksumversion sp is missing).
May be I should change the connectionstring of name="LocalSqlServer"
to be pointing to this new DB (i.e aspnetdb)
And the connectionstring of name="aspnet_staterKits_TimeTracker" to be pointing to TimeTracker database
?
Thanks
OWScott
Participant
1939 Points
360 Posts
ASPInsiders
MVP
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 30, 2005 12:14 AM|LINK
Scott
Microsoft MVP - IIS
Vaasnet
www.vaasnet.com
hmokhtari
Member
8 Points
7 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Oct 26, 2007 07:01 PM|LINK
only need this one. you have to change as follow your connection string in Web.config please:
<
add name="NORTHWNDConnectionString" connectionString="Data Source=here is your servername; Database=Northwind;Integrated Security=True;" />chetan.sarod...
All-Star
66529 Points
11265 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Oct 30, 2007 03:31 AM|LINK
Check in web.config for connectionString, configure it according to your server name, password etc.
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB.
Hope it will help you, let me know.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
thomassamson
Member
7 Points
10 Posts
Re: Error Message: The user instance login flag is not supported on this version of SQL Server. ...
Dec 27, 2007 05:18 PM|LINK
Hi,
This solved an errorI have SQL Server 2005 Developer Edition installed as an instance (computername\SQLServer2005) as the default one is SQL Server 2000. Now i changed the web.config as follows: connectionString="Data Source=.\SQLServer2005;
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: 26 - Error Locating Server/Instance Specified) .
Then when i start the Time Tracker project I get error:
Exception Details: System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
On one of the forum posting it mentioned to run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe (Not sure why, something about allowing SQL Server 2005 to create database from an ASP.net app which it doesn't support unlike SQL Express). Anyway after runnign it a new DB was created in my SQL Server 2005 instance - aspnetdb. As part of the creation i choose Windows integration since i have mixed mode support in my DB (so Windows Authentication works when i use SQL Management STudio) and i figured it should work here. But when i start the Time Tracker app in Visual Web Developer 2005 Express Edition it still causes the error
Exception Details: System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
I don't even see the timetracker database as being created in SQL 2005. When i had tested this app with SQL Express on another machine it created this DB in SQL Express. But i cannot get it to do the same for this SQL Server 2005 Developer Edition instance. Any suggestions would be appreciated.
P.S.: As you notice I'm a complete novice in programming and maybe intermediate in SQL Server so please give detailed steps if possible
Thank you.