Trouble with SQL Server Express 2008 on VPS
Nothing foreshadowed trouble: the site (ASP.NET MVC + MS SQL) was ready and it was time to deploy it for hosting. As a platform, a virtual server based on Hyper-V from Infobox was selected (more details about hosting - under the cut). The script with the database schema was ready and it only remained to run it on the server. And here it appears - SQL Server Express 2008 (the image of Windows Server 2008 + SQL Express 2008 was uploaded to the virtual server).
And the problem was that I could not create a base, due to lack of rights. This is how, “like a poured out of a tub” ©. In the list of logins were Builtin \ Users (wonderful name!) And sa. The first right was public, and I naturally did not know the password from sa.
I was surprised to find out that, when installing SQL Server 2008, the Builtin \ Administrators group with the appropriate permissions (sysadmin) is no longer added. For "security reasons." Let us omit the arguments about the feasibility of this solution, because we are interested in another solution - our rights problem. Microsoft proposes (only in special cases! Achtung! Three times cross!) To start the server with the -f flag, which gives the Administrators group the desired rights. But, alas, either Express does not allow it to be done, or the day was bad, and I did not succeed in this - all I achieved is an empty pop-up with a red cross.
')
Very simple. Reinstalling the Database Engine, when installing, select Mixed Authentication, then go under sa and enjoy life. And if you want to know why I suddenly wrote all this - look under the cat.
Naturally, the first reaction was to create a ticket in support, which I did. I was told right away that they would pass it on to the engineers. The engineer’s response was also extremely operative, polite and meaningless: "This cannot be, becausethis cannot be by default, you have all the rights." When I asked to verify this personally, I was also politely told that I needed to confer with the technical department and they would give me the answer tomorrow. I thanked the support, said that I came across the same on Amazon and they solved the problem, and went to sleep. In the morning I was asked for the login and password from Remote Desktop ... and it’s not that I suspected anything. I just decided that it would be better to reinstall everything at my own peril and risk.
I will not undertake to assess the level of support, but I was surprised that either such a situation was the first time or that I was the first to address them with such a problem. It looks, you see, unlikely.
As for the hosting itself, I'm still satisfied. I chose the server according to the PROMO-512 plan, these are guaranteed 500 MHz, 512 megabytes of RAM, 25 GB of space and shareware traffic. Remote Desktop is fast, the site itself is also. Very amused by the Russian version of Windows Server, still can not get used to the "create a Web site."
Here is a story. Quite by accident it may be useful to someone.
Problem
And the problem was that I could not create a base, due to lack of rights. This is how, “like a poured out of a tub” ©. In the list of logins were Builtin \ Users (wonderful name!) And sa. The first right was public, and I naturally did not know the password from sa.
Investigation
I was surprised to find out that, when installing SQL Server 2008, the Builtin \ Administrators group with the appropriate permissions (sysadmin) is no longer added. For "security reasons." Let us omit the arguments about the feasibility of this solution, because we are interested in another solution - our rights problem. Microsoft proposes (only in special cases! Achtung! Three times cross!) To start the server with the -f flag, which gives the Administrators group the desired rights. But, alas, either Express does not allow it to be done, or the day was bad, and I did not succeed in this - all I achieved is an empty pop-up with a red cross.
')
Decision
Very simple. Reinstalling the Database Engine, when installing, select Mixed Authentication, then go under sa and enjoy life. And if you want to know why I suddenly wrote all this - look under the cat.
Support
Naturally, the first reaction was to create a ticket in support, which I did. I was told right away that they would pass it on to the engineers. The engineer’s response was also extremely operative, polite and meaningless: "This cannot be, because
I will not undertake to assess the level of support, but I was surprised that either such a situation was the first time or that I was the first to address them with such a problem. It looks, you see, unlikely.
As for the hosting itself, I'm still satisfied. I chose the server according to the PROMO-512 plan, these are guaranteed 500 MHz, 512 megabytes of RAM, 25 GB of space and shareware traffic. Remote Desktop is fast, the site itself is also. Very amused by the Russian version of Windows Server, still can not get used to the "create a Web site."
Here is a story. Quite by accident it may be useful to someone.
Source: https://habr.com/ru/post/91464/
All Articles