你安装过程中选用的可能不是SQL 和 WINDOWS 混合登录,用的是系统帐户,请到SQLSERVER企业管理器,右击XXX(WINNT)即SQLSERVER组下面的一个,选择属性,选择安全性,身份验证选择混合登录。
Sorry, after rebuild the system, i found that i can't use the MS-pingyin-98, so only english...^_^My system now is Window2000 server(Tranditional Chinese Version)and SQL 2000 server Enterprise Edition(English Version).In ODBC DNS setting -->System DNS-->configuration First step : Name = LocalServer, Server = LocalServer Second step : I've tried both way to verify the authenticity the Login ID, but they didn't work. And the way jinfeng_wang(G-G-S,D-D-U) you told me, put 'sa' for Login ID and leave the password empty didn't work either.there is a messagebox appeared.// =============================================================== Connection failed: SQLState:'01000' SQL Server Error: 11001 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQLState:'08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. // ===============================================================And the this is the result of the test Data Source in ODBC DSN// =============================================================== Microsoft SQL Server ODBC Driver Version 03.80.0194Running connectivity tests...Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.TESTS FAILED! // =============================================================== wxdxy(晓鹰) I've tried your way too, the same result.. OK, right-click the XXX(WINNT) and choose [Edit the properties]. but i found that there is no 安全性 there, only [General] tab.Thanks to all of you, what you did makes me feel so warm...
Another problem : Any difference between 'Adminitrator' and 'sa'? Are they the same thing? Since all the user-name I use is 'Administrator' not 'sa'. And use 'sa' for the password. Is there a set of standard procedure to install the window2000 server and SQL server that could make it work.
And sorry again for that i can only reply in the night.
freshboy0913(红绿灯) : My computer's OS now is Window2000 server(Tranditional Chinese Version)and SQL 2000 server Enterprise Edition(English Version). I have rebuilt it last night.. ww3347(新来的) : I have disabled the TCP/IP and left only NamePipe, and I did the same thing to the server network utility. But the result is the same.power4(我要多学习!) : In the [Service], the MSSQLSERVER is running but SQLSERVERAGENT is halt.There is sth strange that both in [Service] and [SQL Server Service Manager], when the SQL Server is running, the SQL Server agent is halt, but when I stop the SQL Server, SQL Server agent can be started.LONGFOR(雪婷) : Yes, that is last way to solve it. But my teacher is now in gz, I won't take my computer there to get his help...@_@
I found a good site when I search the solution : http://www.swynk.com
another one : http://fuzzysoftware.com
to LONGFOR(雪婷) WINDOW2000 professional 和NT 是两回事 NT也是服务器用的版本 但WINDOW2000 professional 相当于NT 的WORKSTATION。 所以不能在但WINDOW2000 professional 中装服务器的开发版
OK, A new step..with the hopelessness, I Modified some of the registry table info of the MSSQLSERVER. It is in the HOTKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLSERVER I changed the LoginMode from 0x1 to 0x2. Restart the SQLServer Service and go to the Enterprise Manager to create a Server using 'sa' account.!!! It works. ^_^.. (Still I can't use the localsystem to register a new Server now)But But... I found there was nothing in the database and was going to create a new database in it. The Server Disconnects itself just after I click the Database icon .. !!??
try the following: login as administrator -> start menu -> control panel -> administrate tools -> services -> find a service named just like "SQL....." -> double click on it and check the login option -> change the login option to "local system" -> restart computer.is it ok?
這是不是就是你們說的Administrator???
因爲我試過WINDOW2000 server 也是不行的,搞來搞去搞到WINDOW2000 有點問題,所以就重裝成WINDOW2000 professional試試。。服务管理器在開機的時候就已經開了。。只是Server Agent開不了,使用‘服務’來開也是開不了。 我想是同樣的問題。。
另外,最好不要用2000pro,还是用2000server的好。
2000pro对SQL Server的支持不好。
SQL Server也不要用Develop版,换标准版或者服务器版比较好。
这样多半不会再出问题了。
另外,如果安裝好Window2000Server後,需不需要做點特別的設置才能成爲Adminisrator权限的用户了。。
那你的Window2000和SQL的权限是怎麽設置的了。。
集成认证是不是Authentication?還是Mixed的那種啊?各位大蝦,我使用SQL主要是用來做功課的,眼看著教功課的Deadline就快到了,
系統都還沒有裝好,真是急死人了。。 你們誰能幫我解決這個問題的話,我獨個給他300分。。
但是你讲的
操作系统是WIN2000 SERVER
SQL SERVER 2000 版本为企业版 是不是?
如果是则在你安装过程中选用是不是SQL 和 WINDOWS 混合登录,
SA
First step : Name = LocalServer, Server = LocalServer
Second step : I've tried both way to verify the authenticity the Login ID, but they didn't work. And the way jinfeng_wang(G-G-S,D-D-U) you told me, put 'sa' for Login ID and leave the password empty didn't work either.there is a messagebox appeared.// ===============================================================
Connection failed:
SQLState:'01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified
SQL server not found.
// ===============================================================And the this is the result of the test Data Source in ODBC DSN// ===============================================================
Microsoft SQL Server ODBC Driver Version 03.80.0194Running connectivity tests...Attempting connection
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.TESTS FAILED!
// ===============================================================
wxdxy(晓鹰)
I've tried your way too, the same result..
OK, right-click the XXX(WINNT) and choose [Edit the properties].
but i found that there is no 安全性 there, only [General] tab.Thanks to all of you, what you did makes me feel so warm...
Any difference between 'Adminitrator' and 'sa'?
Are they the same thing?
Since all the user-name I use is 'Administrator' not 'sa'.
And use 'sa' for the password.
Is there a set of standard procedure to install the window2000 server and SQL server that could make it work.
7.0的时候有过这个问题,我也不明白为什么?有的用命名管道就可以,有的就不行。
mssqlserver的.\Administrator服务!
或者修改一下属性!
我想你是在单机上装的SQL Sever 2000吧,在windows 2000 professional版上根本不能安装数据库服务器,只能装客户端服务工具,这些工具(当然也包括企业管理器啦)的用途是在一个LAN内记问已存在的数据库(这些数据库位于LAN内的某些服务器上,当然这些服务器的OS也必须是windows 2000 sever 版) 想想连数据库服务器都没有,用企业管理器登录到哪儿呢? 在单机上装数据库服务器唯一的办法是:将你的操作系统换成windows 2000 Sever版
如果你选择SQL帐号登录时,用么用系统管理员帐号sa和密码(这个密码在安装SQL Sever后第一次使用时为空),也可以用SQL管理员分配给你的帐号和密码登录,唯一要注意的是这个帐号要已经建立。如果SQL Sever中并没有administrator帐号时(如果没有管理员建立它,这个帐号并不是默认存在的)你的登录当然不会成功。 你可能用sa帐号登录。密码为空试试。
My computer's OS now is Window2000 server(Tranditional Chinese Version)and SQL 2000 server Enterprise Edition(English Version).
I have rebuilt it last night..
ww3347(新来的) :
I have disabled the TCP/IP and left only NamePipe, and I did the same thing to the server network utility. But the result is the same.power4(我要多学习!) :
In the [Service], the MSSQLSERVER is running but SQLSERVERAGENT is halt.There is sth strange that both in [Service] and [SQL Server Service Manager], when the SQL Server is running, the SQL Server agent is halt, but when I stop the SQL Server, SQL Server agent can be started.LONGFOR(雪婷) :
Yes, that is last way to solve it.
But my teacher is now in gz, I won't take my computer there to get his help...@_@
WINDOW2000 professional 和NT 是两回事
NT也是服务器用的版本
但WINDOW2000 professional 相当于NT 的WORKSTATION。
所以不能在但WINDOW2000 professional 中装服务器的开发版
I Modified some of the registry table info of the MSSQLSERVER.
It is in the HOTKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLSERVER
I changed the LoginMode from 0x1 to 0x2.
Restart the SQLServer Service and go to the Enterprise Manager to create a Server using 'sa' account.!!! It works. ^_^.. (Still I can't use the localsystem to register a new Server now)But But... I found there was nothing in the database and was going to create a new database in it. The Server Disconnects itself just after I click the Database icon .. !!??
login as administrator -> start menu -> control panel -> administrate tools -> services -> find a service named just like "SQL....." -> double click on it and check the login option -> change the login option to "local system" -> restart computer.is it ok?