Well, older version of SQL server is not compatible with Windows Vista. But SQL server 2005 standard edition and SQL server express edition is highly compatible with window Vista. But today, when I installed SQL server 2005 Standard edition in my Laptop with its service pack two (SP2) and tried to create a database, a ridiculous error message was displayed as given below.
Created failed for Database ‘XXX(Microsoft.Sql.Server.Smo)
Error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Connectioninfo)
CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, Error: 262) – Error in Windows Vista
I applied all my ideas to create simple things like new database and tables but my every attempt ended with the outcome of the above error message. In SQL server 7.0 the login username was ‘Sa’ but in SQL server 2005 this even doesn’t work properly. So at last I decided to search the error message over the internet and within 10 minutes I got the solution from Microsoft official website. It was quite complicated but I have now simplified it to just three points.
Solution for Microsoft SQL Server, Error: 262
- Click on Start -> Click in Microsoft SQL Server 2005
- Now right click on SQL Server Management Studio
- Click on Run as administrator
Now the problem is solved. This is the actual process to login to our SQL server 2005 as an administrator with all the administrative rights. But I think in Microsoft SQL Server 2005 express edition we do not need to go through the above process. Well my problem is solved and tomorrow I am going to connect my VB.net project with SQL server 2005. Goodnight friends!