Test Problem :
In My Asp.Net web appllication, I couldn't connect sql server from project.No connection error, no user authentication error.
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
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.
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.
I think my problem with;
Windows 7 Home Premium 64 bit OS directory authentication or
Windows 7 Home Premium IIS configuration settings.
Database Directory:Default sql Data file.
I'm tring to solve my problem.Please help me.
Thanks in advance.