Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rupaj
Starting Member
4 Posts |
 Posted - 2007-10-19 : 14:45:17
|
| Hi,I am running out of an error with MS SQL 2005. We were initially able to connect to the server. This database is created to connect with the siebel CRM application. while configuring the SSE role using the grantusr.sql, we were unable to connect to the database which is created in mixed mode authentication.we are getting the following error,"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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)"And in the event viewer logs we found the below error:login failed for user ' '.the user is not associated with atrusted SQL server connection"Please help us in this matter. Its urgent. Any help would be highly appreaciated. thanks in advance.roopadevi.j |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 00:18:55
|
| Did you specify correct sql login and password? Correct sql instance name? Is tcp/ip enabled on the server? Did you enable remote access on the server? |
 |
|
|
rupaj
Starting Member
4 Posts |
Posted - 2007-10-22 : 11:17:52
|
| Hi,i have provided the correct login username/pwd. and the server name provided was also correct.but then we are unable to connect to the server. how to check if tcp/ip is enabled ? I am unable to start the sql server agent also...please help!!!!!roopadevi.j |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 22:37:24
|
| Check those in sql server configuration manager and surface area configuration, find out why sql agent didn't start in windows app event log. |
|
|
|
rupaj
Starting Member
4 Posts |
Posted - 2007-10-23 : 10:26:02
|
| Hi,I have checked the eventviewer logs for not starting the SQL server agent.it says"SQL server agent could not be started [reason: unable to connect to server 'server name';SQL server agent cannot start"what else should be checked now...?thanks!!!!roopadevi.j |
|
|
|
rupaj
Starting Member
4 Posts |
Posted - 2007-10-23 : 13:59:49
|
| Hi,I have also enabled the remote connection option through the SQL surface area configuration and connections. I do not have any firewall also.what could be the possible reason for the issue then?should i need to install any service packs to get out of the error?thanks!!!!!roopadevi.j |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-23 : 22:52:46
|
| Is sql server service running? |
|
|
|
|
|
|
Login failed for user