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;Initial Catalog=productdb;User Id=xx;Password=xxx;";

it worked
untitled55.bmp
LVL 1
doramail05Asked:
Who is Participating?
 
doramail05Connect With a Mentor Author Commented:
got it already.

fixed with sql server express 2008 sp1.
0
 
Christopher GordonSenior Developer AnalystCommented:
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.
0
 
Christopher GordonSenior Developer AnalystCommented:
if that ends up being your issue here is a link that might be helpful:
http://kbase.gfi.com/showarticle.asp?id=KBID002804
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
doramail05Author Commented:
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
0
 
Christopher GordonSenior Developer AnalystCommented:
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?
0
 
doramail05Author Commented:
it is mixed mode while login into sql server from management studio by default, that i didnt change it.

0
 
Christopher GordonSenior Developer AnalystCommented:
great!  sorry wasn't able to help
0
All Courses

From novice to tech pro — start learning today.