如何使用Sql'05 Exp解决我的身份验证问题.在Win 7 Home Premium 64位OS中 [英] How to solve my authentication problem with Sql'05 Exp. in Win 7 Home Premium 64 Bit OS
问题描述
测试问题:
在My Asp.Net Web应用程序中，我无法从项目连接sql服务器.没有连接错误，没有用户身份验证错误.
项目环境:
ASP.Net，C#3.5，SQL Express 2005(标准最终测试数据库服务器)
系统详细信息出现问题:
Windows 7家庭高级版64位OS Framework 3.5，SQL Server 2005 Express
案例:
项目正常运行，尝试连接sql server时发生错误.只是示例错误"和sqlDB连接详细信息.没有异常详细信息.
详细信息:
我还测试了我的项目Windows XP Pro SP3(32位操作系统)，Windows 7 Professional和Ultimate(32位操作系统).Windows Server 2008 64位操作系统.
但是在64位系统中，我遇到了一些问题.
首先，我无法安装sql server Exp.通常情况下，2005 Management Studio.
然后我解决了这样的问题；我将"sql .... Msi"文件复制到C目录，并以管理员身份运行命令提示符，并从命令提示符运行安装过程.此后，我无法正确附加数据库文件，该文件已附加(只读)然后将我的standart db文件位置更改为sql server标准数据位置.它工作正常，并且我从SSMS正常连接到sql server.
当我无法连接sql server时，我更改了标准连接字符串.我尝试以Windows身份验证和sql server身份验证进行连接.但是没有连接错误没有身份验证错误发生.
也许:
我认为我的问题；
Windows 7 Home Premium 64位OS目录身份验证或
Windows 7 Home Premium IIS配置设置.
项目目录:C:\ inetpub \ wwwroot \ Prjct
数据库目录:默认sql数据文件.
我正在努力解决我的问题.请帮助我.
在此先感谢您.
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.
推荐答案
您是否将应用程序构建为以32位为目标?如果没有，请尝试.如果这行得通，那么您的问题是您正在某个地方使用32位dll，或者甚至是您的SQL Server版本?
Do you build your app to target 32 bit ? If not, try it. If this works, your problem is that you''re using a 32 bit dll somewhere, or perhaps even your SQL server version ?
这篇关于如何使用Sql'05 Exp解决我的身份验证问题.在Win 7 Home Premium 64位OS中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
