doramail05
asked on
Failed to generate a user instance of SQL Server 2008
i try both strong-typed dataset and sqldatasource to get connection from sql server 2008 but it gave me error like :
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
while using conventional connection like describing connstring :
private static string connstring = "Data Source=123\\SQLEXPRESS;Ini tial Catalog=productdb;User Id=xx;Password=xxx;";
it worked
untitled55.bmp
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
while using conventional connection like describing connstring :
private static string connstring = "Data Source=123\\SQLEXPRESS;Ini
it worked
untitled55.bmp
Is this a new instance of SQL Server? Based on the error message, the box may not have been configured to accept SQL authentication. For some reason this is the default for SQL Server instance install.
if that ends up being your issue here is a link that might be helpful:
http://kbase.gfi.com/showarticle.asp?id=KBID002804
http://kbase.gfi.com/showarticle.asp?id=KBID002804
ASKER
ok. i followed the article and try to configure, but found that they are default settings. no changes being made, and the issue hanging still
OK, just to make sure I understand, it was not configured for Mixed Mode? So, you made the configuration change, restarted the SQL server service, and you're still getting the same error?
If you check the properties, is it still Windows Authentication only mode?
If you check the properties, is it still Windows Authentication only mode?
ASKER
it is mixed mode while login into sql server from management studio by default, that i didnt change it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
great! sorry wasn't able to help