i wrote my problem before also...n it was
I have installed SQL SERVER 2005 CTP,Version 9.00.1314 but the problem is...as soon as i m trying to connect..i gave the local server name as SHUCHI during the installation and now i m trying to connect to it... then it gives me error as :
cannot connect to SHUCHI
additional information: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)(Microsoft SQL Server,Error:2)
n now i think i have another problem...this problem is still there and no one could tell me the right solution :(( ....n now when i saw the sql configuration tool i found that in the SQL SERVER 2005 NETWORK CONFIGURATION there are NO PROTOCOLS at all...in short i think they r not installed at all...i tried to install the SQL SERVER thrice but the problem is stil the same....can someone tell me...if i can just install these protocols only from somewhere>?
please try to HELP MEEEEE.....
thnks,
shuch.Are you inside SAC (Surace Area Configuration)?
You need to enable the protocols.
After that, you need to enable remote connections.
|||
For more information about SAC, see BOL topic:
http://msdn2.microsoft.com/en-us/library/ms230995(en-US,SQL.90).aspx
|||Hi,the problem is that as soon as i click on SAC...the ERROR comes and it tells me that i m not in the ADMINISTRATOR's group ...n the sad part is that I M in the administrator group...is there any way from where i can download just the SQL SERVER 2005 NETWORK CONFIGURATION...so as to get the PROTOCOLS n everythin...or if there is some other way to do it in the SAC only..but i cant click anything in there since it gives me ERROR....i thought may b the problem is with installation so i REINSTALLED it THRICE but all the times the problem still exist...
please try to think of somethin n PLEASEEE HELP ME..
thnks for your reply,
shuchi.|||
What OS are you using?
How are you logged into your machine?
Can you verify that you're in the Administrator's group?
Can you verify that you logged into the machine with an account that belongs in the Administrator's group?
Did you try logging into your machine as Administrator?
i have a user name and a password to log into my machine(since its a company),
yeah...in the groups i saw my name in the ADMINISTRATOR's group(even the admin told me that me that i m there in the group),
i didnt try logging as administrator on my machine...i can try that on monday...but i dont knw if its really goin to help or not...since its not connectin with the server at all...anyways,i will try n write my reply again on monday..thnks for ur suggestions though...
No comments:
Post a Comment