| Author |
Topic |
|
saranyabaskaran
Starting Member
10 Posts |
 Posted - 2010-12-29 : 01:16:12
|
| hai, iv installed my sql server 2005 in windows authentication mode..But i could not access the server ... wat is the problem here?.. and wat steps i need to take in order to access the database... |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-29 : 01:36:01
|
| What is the error ?PBUH |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 01:43:12
|
| And how are you trying to access it.Is it a default or named instance.Are you connecting from the server or remotely.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-29 : 02:54:51
|
| error is:An error has occurred 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..this was the error it is showing me ... i dnt hav any remote server.. iv instaled sql server 2005 in my lap.. after that wen i clikd connect button, bt it is not conecting... i dnt no wat mistake i did...$aranya |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 03:19:06
|
| Have a look at the services - is the sql server started?What is the o/s and is it a default instance?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-29 : 03:41:57
|
| Goto SQL Configuration Manager under SQL Server Network Configuration>>Protocols for SQLEXPRESS enable the Status for Shared Memory.PBUH |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-29 : 04:18:31
|
| no it is the sql server is not yet started.. my os is windows xp... wat u mean by default instance?... i culd not understand...the shared memory is enabled ..iv chekd it already...is there any other solution 2this?$aranya |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-29 : 04:23:48
|
| and iv another doubt... wer does this server available... is it a default server?..is it enabled automatically once v installed sql server 2005..? wer does it exist in case of windows authentication?.... how 2 see its name?...plz tell me ya..$aranya |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 04:30:05
|
| You need to start the sql server service before you can connect.If you didn't specify a named instance durin installation then it's probably a default instance.You can connect using the name . or (local) or the machine name once the service is started.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-29 : 04:30:12
|
quote:
no it is the sql server is not yet started..
The sql service has not started.Goto Run>>services.msc>>Look for service name SQL Server>>Right click and select start.PBUH |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-29 : 04:35:58
|
 PBUH |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-29 : 09:23:48
|
| i did..bt it is showing me an error saying windows could not start the sql server on local computer. for more info ,review the system event log. if this is a non-microsoft service contact the service vendor, and refer to service-specific error code 17051.$aranya |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 21:02:19
|
| Well that's your problem. SQL Server can't start.Did you get any errors when you installed?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-30 : 01:54:35
|
| no..i didnt get errors while installing...it was installed successfully..how to see the application log?..$aranya |
|
|
|
naveengopinathasari
Yak Posting Veteran
60 Posts |
Posted - 2010-12-30 : 04:09:44
|
| Read the below linkI guess this is not working on Name pipes or TCPIyou need to enable all the network connection, it will be likeenabling all the option to YESread it herehttp://support.microsoft.com/kb/914277Lets unLearn |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-30 : 06:53:28
|
| could u plz tell me where is the log file 2see the errors.. bcz watevr the steps i follow it is asking me to check the application log file....$aranya |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2010-12-30 : 06:56:45
|
| im not able to start the service on local host... i followed all the steps given in that link...but still its showing me the error...$aranya |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-30 : 12:21:45
|
quote:
Originally posted by tkizer
What does the application log in Event Viewer show for the actual error?
^ thisstart/run/eventvwr |
|
|
|
saranyabaskaran
Starting Member
10 Posts |
Posted - 2011-01-05 : 09:30:50
|
| FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.this was error it is showing in the application log$aranya |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
|
|
Next Page
|
problem in conecting to server...