July 7, 2009 at 9:41 am
I am a user for SQL Server with Wonderware InTouch. InTouch is a process visualization tool. InTouch is using the SQL Server for the Alarmdatabases and recipe handling.
I want to add a few SQL-jobs to the server for deleting data which are older than one year. I tested all that on my office PC and it was running perfect.
Now I want to add the jobs to the server of the customer. To handle SQL jobs it is necessary to run the SQL-Server Agent. The SQL server agent will not start.
When I am starting the SQL Server Agent this massage is popping up:
Error connecting to the server. When connecting to SQL Server 2005 may cause this error are that the SQL Server default remote connections are not allowed. (provider: Named Pipes Provider, error: 40 - Connection with SQL Server could not be opened) (Microsoft SQL Server, Error: 53)
also when I will connect the SQL database from the customer with my office SQL Server this error is showing.
And this condition is since the customers PC got a new name and is connected to their domain.
Before there was no problem about this.
What must I do to get access to the SQL Server agent?
The Server is running on Win XP professional.
The SQL Server is SQL Server 2005
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
July 7, 2009 at 9:49 am
Karsten (7/7/2009)
I am a user for SQL Server with Wonderware InTouch. InTouch is a process visualization tool. InTouch is using the SQL Server for the Alarmdatabases and recipe handling.I want to add a few SQL-jobs to the server for deleting data which are older than one year. I tested all that on my office PC and it was running perfect.
Now I want to add the jobs to the server of the customer. To handle SQL jobs it is necessary to run the SQL-Server Agent. The SQL server agent will not start.
When I am starting the SQL Server Agent this massage is popping up:
Error connecting to the server. When connecting to SQL Server 2005 may cause this error are that the SQL Server default remote connections are not allowed. (provider: Named Pipes Provider, error: 40 - Connection with SQL Server could not be opened) (Microsoft SQL Server, Error: 53)
also when I will connect the SQL database from the customer with my office SQL Server this error is showing.
And this condition is since the customers PC got a new name and is connected to their domain.
Before there was no problem about this.
What must I do to get access to the SQL Server agent?
The Server is running on Win XP professional.
The SQL Server is SQL Server 2005
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
sounds like you have a few issues here
1 - check servername
select @@servername,serverproperty('machinename')
if both values are different then you need to
exec sp_dropserver 'oldservername'
exec sp_addserver 'newservername','local'
2) if you are having connection issues to the Server after it has renamed, then check the firewall to see if it is now blocked??
3) try connecting to it via IP address rather than net name
4) if it's been added to the domain then permissions for the sql agent service account may be wrong - try adding an account in to local admins on the server and set the service to run as this - (AS A TEST ONLY - this is not best practice)
MVDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply