please help me in fixing this bug...................!!

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.

http://forums.asp.net/p/981020/1750831.aspx#1750831

Please - OLE DB Provider for SQL Server (0x80004005) Cannot generate SSPI context

Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

I am using Windows 2000 Service Pack 4 with Internet Exp. 6. The system also has developing software VB6 and IIS. It is connecting well with VB application but is not accessing through IIS.

I have checked all MS Knowledge Base but could not find workaround. MS accepts it as a bug but I could not find quick and easy solution,

Thanking you in anticipation,

Zulfiqar AliSSPI points to an authentication error connecting to your SQL Server instance.

have you tried creating a SQL Server logon and passing that to your connection string? If that works, then there's an issue with your Windows authentication.....

If it doesn't, then you have a more general problem connecting to your database|||

No, but to do this, I need to re-install the SQL server. I am trying to avoid this. Is it possible to change main SQL server login without re-installing SQL Server?

Regards

|||hata error