Showing posts with label whenever. Show all posts
Showing posts with label whenever. Show all posts

Friday, February 24, 2012

change sqlvdi.dll IdentifySQLServer

I've inherited a SQL 2005 Server with SP2 installed that throws this error whenever it's backed up via EMC Insignia's Retrospect 7.5:

Source: SQLVDI
Event ID: 1

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY1. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=4788. Thread=4672. Client. Instance=DATALIBRARY1. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

As far as I can tell, the name should be DATALIBRARY, not DATALIBRARY1. Is there a way to change that reference without having to uninstall / reinstall?

Thanks,

- Al

If the SQL instance is named DATALIBRARY, then you'll need to look at the Retrospect configuration to see why it's using the wrong name. It may be as simple as revising the Retrospect backup job. I don't have a copy of Retrospect to play with, so I can't tell exactly how that would be done.|||Thanks Kevin. After uninstalling / re-installing the Retrospect client countless times, I was finally able to get it to sync with the SQL instance DATALIBRARY. Now I'm getting the same error message with the correct server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other ideas / troubleshooting I can try?

Thanks,

- Al

|||Thanks Kevin.

I uninstalled / re-installed the Retrospect client and was able to get the client to sync up with the correct SQL instance name. Now the error message is the same, except that it points to the correct name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting you can think of?

Thanks,

- Al

|||Thanks Kevin,

I uninstalled / re-installed the Retrospect client and was able to pick up the correct SQL instance name. Now we're logging the same error with the right server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting tips I can try?

Thanks,

- Al

change sqlvdi.dll IdentifySQLServer

I've inherited a SQL 2005 Server with SP2 installed that throws this error whenever it's backed up via EMC Insignia's Retrospect 7.5:

Source: SQLVDI
Event ID: 1

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY1. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=4788. Thread=4672. Client. Instance=DATALIBRARY1. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

As far as I can tell, the name should be DATALIBRARY, not DATALIBRARY1. Is there a way to change that reference without having to uninstall / reinstall?

Thanks,

- AlIf the SQL instance is named DATALIBRARY, then you'll need to look at the Retrospect configuration to see why it's using the wrong name. It may be as simple as revising the Retrospect backup job. I don't have a copy of Retrospect to play with, so I can't tell exactly how that would be done.|||Thanks Kevin. After uninstalling / re-installing the Retrospect client countless times, I was finally able to get it to sync with the SQL instance DATALIBRARY. Now I'm getting the same error message with the correct server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other ideas / troubleshooting I can try?

Thanks,

- Al|||Thanks Kevin.

I uninstalled / re-installed the Retrospect client and was able to get the client to sync up with the correct SQL instance name. Now the error message is the same, except that it points to the correct name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting you can think of?

Thanks,

- Al|||Thanks Kevin,

I uninstalled / re-installed the Retrospect client and was able to pick up the correct SQL instance name. Now we're logging the same error with the right server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting tips I can try?

Thanks,

- Al

change sqlvdi.dll IdentifySQLServer

I've inherited a SQL 2005 Server with SP2 installed that throws this error whenever it's backed up via EMC Insignia's Retrospect 7.5:

Source: SQLVDI
Event ID: 1

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY1. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=4788. Thread=4672. Client. Instance=DATALIBRARY1. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

As far as I can tell, the name should be DATALIBRARY, not DATALIBRARY1. Is there a way to change that reference without having to uninstall / reinstall?

Thanks,

- AlIf the SQL instance is named DATALIBRARY, then you'll need to look at the Retrospect configuration to see why it's using the wrong name. It may be as simple as revising the Retrospect backup job. I don't have a copy of Retrospect to play with, so I can't tell exactly how that would be done.|||Thanks Kevin. After uninstalling / re-installing the Retrospect client countless times, I was finally able to get it to sync with the SQL instance DATALIBRARY. Now I'm getting the same error message with the correct server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other ideas / troubleshooting I can try?

Thanks,

- Al|||Thanks Kevin.

I uninstalled / re-installed the Retrospect client and was able to get the client to sync up with the correct SQL instance name. Now the error message is the same, except that it points to the correct name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting you can think of?

Thanks,

- Al|||Thanks Kevin,

I uninstalled / re-installed the Retrospect client and was able to pick up the correct SQL instance name. Now we're logging the same error with the right server name:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=2540. Thread=2760. Client. Instance=DATALIBRARY. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any other troubleshooting tips I can try?

Thanks,

- Al

Sunday, February 12, 2012

Change of NT password user affect to service

Dear all,
Whenever that I change my password on domain NT, then MSSQLSERVER
service failed (local sql server of course). So that I've got to enter in
that service
and update the password manually on LOG ON flap.
At the same time when I open my enterprise manager not appears all those
Network Sql Serverthat before I had. '?
I would like to have automatically this change.
Any help will be welcomed,
Thanks in advance,Enric,
That means that the service is using your account and every time you change
your password, you have to update the service.
Why you do not create an account just for the service?
See "Setting up Windows Services Accounts" in BOL.
AMB
"Enric" wrote:

> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '?
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||It is better to create a special service account rather than using your own
for SQL Server services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||Local System Account?
take care,
"Dan Guzman" wrote:

> It is better to create a special service account rather than using your ow
n
> for SQL Server services.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
>
>|||Enric,
He meant a "domain user account".
AMB
"Enric" wrote:
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>|||You could use the build-in Local System account if access to network
resources isn't needed (e.g. backup to UNC). As Alejandro suggested, I was
thinking of a domain account since this is apparently what you are currently
using.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:E2E61BAB-6C00-4B9A-AC44-FCD759E22E6E@.microsoft.com...
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>