How to solve my authentication problem with Sql'05 Exp. in Win 7 Home Premium 64 Bit OS

May 25 2010 3:36 AM

Test Problem     :
In My Asp.Net web appllication, I couldn't connect sql server from project.No connection error, no user authentication error.
Project Environment:
ASP.Net, C#3.5, SQL Express 2005(Standart end test DB server)
Problem with System Details   :
Windows 7 Home Premium (64 bit OS) Framework 3.5, SQL Server 2005 Express
Case             :
Project run normally and when try to connect sql server then error occured.No error details; just "Sample Error" and sqlDB connection details.No exception details.

Details          :
I tested my project also Windows XP Pro SP3 (32 bit OS), Windows 7 Professional and Ultimate (32 bit OS).Windows Server 2008 64 bit OS.Its worked fine.
But in 64 bit systems i come accross some problems.
Firstly i couldn't install sql server Exp. 2005 Management Studio normally. 
Then i solve the problem like that; i copied "sql....Msi" file to C directory and run command prompt as administrator and run installation process from command promp.After that i couldn't attached my database file properly it's attached (read-only).Then i changed my standart db file location to sql server standart data location.It worked fine and i connected to sql server from SSMS normally.
When i couldn't connected sql server i change my standard connection string.I've tried to connected as windows authentication and sql server authentication.But no connection error no authentication error occured.

Maybe:
I think my problem with;
Windows 7 Home Premium 64 bit OS directory authentication or
Windows 7 Home Premium IIS configuration settings.
Project Directory:C:\inetpub\wwwroot\Prjct
Database Directory:Default sql Data file.
I'm tring to solve my problem.Please help me.
Thanks in advance.

Answers (1)