Windows 7上的sql server2005 [英] sql server2005 on windows 7

问题描述

嗨 我是sql server2005的新用户
我用xp安装sqlserver2005可以正常工作.
但是现在我在Windows7中工作成功了，
但是当我为sqlserver启动mangementstudio时
当我单击连接问题时显示用户名
什么问题.有人会建议我对此做出回答吗?
我认为是Windows7的问题
当我单击连接按钮时，问题就是这样

用户'abc \ username'登录失败.(Microsoft SQL Server，错误:18456)" 

感谢和问候
Umesh Daiya

解决方案

检查您的服务器名称:" [YourComputerName] \ SQLEXPRESS

用户名:" sa

密码:"(如果您在安装时输入)

你好

您是否尝试在sql server 2005中使用Windows身份验证登录?

Windows 7可能不直接允许窗口身份验证，您必须从Sql Server外围应用程序中更改某些设置，否则请使用sa帐户登录

hi i am new user of sql server2005
i install sqlserver2005 with xp its work fine.
but now a days i work in windows7 its installed successfully
but when i start mangementstudio for sqlserver
when i click on connect problem show username
what the problem. will any body suggest me answer for this
its problem of windows7 i think
problem is like this when i click on connect button

"Login Failed for user 'abc\username'. (Microsoft SQL Server, Error: 18456)"

thanks and regards
Umesh Daiya

解决方案

Check your "Server Name :" [YourComputerName]\SQLEXPRESS

"UserName :" sa

"Password :" (if you gave while install)

hello

are you trying do login with the windows authentication in sql server 2005??

windows 7 might not directly allow window authentication, you have to change some setting from Sql Server Surface Area else login with sa account

这篇关于Windows 7上的sql server2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！