July 7, 2009 at 9:25 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 Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer7.0.5730.13
Microsoft .NET Framework2.0.50727.1433
Operating System5.1.2600
July 7, 2009 at 9:46 am
So the box you have SQL running on had the hostname changed?
What is the SQL services running as (local system, domain account, etc)?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 7, 2009 at 9:50 am
The mashine was running as local system when I installed the sql server. Later the computer got a new name and was connected to a domain.
The services (jobs) should run on the local mashine.
The SQL databases are on the computer where the sql Server is running. This computer is connected to a domain. The system admin connected the computer only for getting printer connection -> don't ask me why.
regards
karsten
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply