Firstly: I am not MS SQL Developer, and I have no experience with it. I have had to use it as a part VAMT database of keys and activations.

There is 8.1 box with MS SQL (express I think).

After change host name I cannot connect to database with error "The specified database is not a valid VAMT database."

Looking into log gives me: Could not obtain information about Windows NT group/user 'lit\kjonca', error code 0x534."

Some googling suggest me:

to use:

sp_dropserver "..."  and sp_addserver '...', local
but with no effect :(
any other ideas?

"the internal SQL Server name is based on the physical server name, but changing the physical server name does not update the metadata within SQL Server"

Refere to the following links.

http://www.mssqltips.com/sqlservertip/2525/steps-to-change-the-server-name-for-a-sql-server-machine/

https://msdn.microsoft.com/en-us/library/ms143799.aspx

Looking into log gives me: Could not obtain information about Windows NT group/user 'lit\kjonca', error code 0x534."

Looking into log gives me: Could not obtain information about Windows NT group/user 'lit\kjonca', error code 0x534."

Do you have SA password can you login and check whether account lit\kjonca exists in logins or if it is part of any group can you check that this login is part of a that

Looking into log gives me: Could not obtain information about Windows NT group/user 'lit\kjonca', error code 0x534."

Do you have SA password can you login and check whether account lit\kjonca exists in logins or if it is part of any group can you check that this login is part of a that

> do you have SQL Server management installed and most of it do you have password of SA ?

"SQL Server Configuration management" this is the only thing I can see.

I do not know if I have password of SA, and how to check if any exists.

>Can you ask whoever has installed the SQL Server

After change host name I cannot connect to database

Hello,

Please have a look at Rename a Computer that Hosts a Stand-Alone Instance of SQL Server for all steps after changing a host name.

After change host name I cannot connect to database

Hello,

Please have a look at [...link removed... ] for all steps after changing a host name.

Hello

regarding the usename 'lit\kjonca'; was this a local Server logon that existed before you renamed the Server?

Hello

regarding the usename 'lit\kjonca'; was this a local Server logon that existed before you renamed the Server?

Yes,

kjonca - my account

lit - old host name

lis - new host name

Hi kjonca,

From your description, you are using the Windows login that in oldhostname\username' format to connect to SQL Server database. The login doesn't work because you have changed the host name.

If you don't know 'sa' password, start SQL-Server in single-user mode in which any local administrator has access , then create a new login in newhostname\username format and grant it proper permission on your database. For more details, please review this article

Thanks,
Lydia

Hello

regarding the usename 'lit\kjonca'; was this a local Server logon that existed before you renamed the Server?

Yes,

kjonca - my account

lit - old host name

lis - new host name

Then this is the issue.

Hopefully the BUILTIN\Administrators group still has SysAdmin access in SQL Server.

Create yourself a new Local Admin account LIS\kjonca ; log off your machine, log on as LIS\kjonca and try and log into SQL Server.

Hi kjonca,

From your description, you are using the Windows login that in oldhostname\username' format to connect to SQL Server database. The login doesn't work because you have changed the host name.

If you don't know 'sa' password, start SQL-Server in single-user mode in which any local administrator has access , then create a new login in newhostname\username format and grant it proper permission on your database. For more details, please review this [..link...cut...]

Thanks,
Lydia

Drop the Lis\KJONCA login and then recreate it. (note you will have to be logged on as another user with admin rights to do this).

When you renamed the Server any Lit login will have been renamed as Lis; however SQL Server doesn't like that sort of behaviour as it will not recognise the login certificate any more.

Drop the Lis\KJONCA login and then recreate it. (note you will have to be logged on as another user with admin rights to do

Ok..

Can you run the command select * from syslogins (from the master database) and see if that returns any results?

Finally I got it working I think.

1. Restored from backup state where server name was "LIT"

2. We have local account "kjonca" which i member of Admnistrator group

3. Change host name to "LIS"

4. add "-m" to run parameters of sqlserver, and run in "single user  mode"

5. run elevated cmd.exe

6. sqlcmd -S lis\adk

6a. sp_dropserver 'lit\adk'

6b. sp_addserver 'lis\adk',local

7. create local windows account "temp" - member of administrators

8. login as "TEMP" user

9. run elevated cmd.exe

10. sqlcmd -S lis\adk

10a. DROP LOGIN [LIT\KJONCA];

10b DROP LOGIN [LIS\KJONCA] ; # only for sure

10c. CREATE LOGIN [LIS\KJONCA] FROM WINDOWS;

10d. ALTER SERVER ROLE sysadmin ADD MEMBER [LIS\KJONCA];

11. remove "-m" from mssql parameters, restart server

12. login as kjonca

13. vamt works

thank to everybody,

• Edited by kjonca 13 hours 59 minutes ago

Finally I got it working I think.

1. Restored from backup state where server name was "LIT"

2. We have local account "kjonca" which i member of Admnistrator group

3. Change host name to "LIS"

4. add "-m" to run parameters of sqlserver, and run in "single user  mode"

5. run elevated cmd.exe

6. sqlcmd -S lis\adk

6a. sp_dropserver 'lit\adk'

6b. sp_addserver 'lis\adk',local

7. create local windows account "temp" - member of administrators

8. login as "TEMP" user

9. run elevated cmd.exe

10. sqlcmd -S lis\adk

10a. DROP LOGIN [LIT\KJONCA];

10b DROP LOGIN [LIS\KJONCA] ; # only for sure

10c. CREATE LOGIN [LIS\KJONCA] FROM WINDOWS;

10d. ALTER SERVER ROLE sysadmin ADD MEMBER [LIS\KJONCA];

11. remove "-m" from mssql parameters, restart server

12. login as kjonca

13. vamt works

thank to everybody,

• Edited by kjonca Friday, July 03, 2015 5:08 PM