Stupid @#$()*@#$ MSDE
-
Ok, this Microsoft SqlServer Desktop Edition is driving me nuts.. In particular the (lack of) documentation. I installed this tepid pos, then happily downloaded the appropriate SP3, and ran it.. SP3 rudely told me that the SA had no password and I had to assign it one (which I wanted to anyway), and mentioned something about a SAPWD switch. This is when the (not) fun part started. I could not find anyplace where to set the sa password.. Or any documentation on it. Perhaps I am just half blind, and stupid as well and not able to see it, but if anyone can tell me how, or where I can find the information I would highly appreciate it. /CMH
-
Ok, this Microsoft SqlServer Desktop Edition is driving me nuts.. In particular the (lack of) documentation. I installed this tepid pos, then happily downloaded the appropriate SP3, and ran it.. SP3 rudely told me that the SA had no password and I had to assign it one (which I wanted to anyway), and mentioned something about a SAPWD switch. This is when the (not) fun part started. I could not find anyplace where to set the sa password.. Or any documentation on it. Perhaps I am just half blind, and stupid as well and not able to see it, but if anyone can tell me how, or where I can find the information I would highly appreciate it. /CMH
If you have the enterpise manager installed, open it up, go into the users section under the server name, select the user (sa) and bring up the properties, and there is a password field, which you type the password into, and click Ok. Its more straight forward than you think. Quote from a clever bloke : "I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones." - Albert Einstein
-
Ok, this Microsoft SqlServer Desktop Edition is driving me nuts.. In particular the (lack of) documentation. I installed this tepid pos, then happily downloaded the appropriate SP3, and ran it.. SP3 rudely told me that the SA had no password and I had to assign it one (which I wanted to anyway), and mentioned something about a SAPWD switch. This is when the (not) fun part started. I could not find anyplace where to set the sa password.. Or any documentation on it. Perhaps I am just half blind, and stupid as well and not able to see it, but if anyone can tell me how, or where I can find the information I would highly appreciate it. /CMH
May be I am utterly wrong, but I can see two ways of doing so : - You can change the MSDE Service credentials by opening up the control panel / administrative tool / Services - MS Access can be used as a front end to access SQLServer system tables. More info here[^]. [Edit]Even more info here[^][/Edit]
-
Ok, this Microsoft SqlServer Desktop Edition is driving me nuts.. In particular the (lack of) documentation. I installed this tepid pos, then happily downloaded the appropriate SP3, and ran it.. SP3 rudely told me that the SA had no password and I had to assign it one (which I wanted to anyway), and mentioned something about a SAPWD switch. This is when the (not) fun part started. I could not find anyplace where to set the sa password.. Or any documentation on it. Perhaps I am just half blind, and stupid as well and not able to see it, but if anyone can tell me how, or where I can find the information I would highly appreciate it. /CMH
Almost all SQL Server documentation also applies to MSDE. To set the password, login using osql.exe and execute sp_password "was wir auch tun, wohin wir gehen die illuminaten sind im system sie kontrollieren überall und 23 ist ihre zahl!" 23, welle: erdball
-
Ok, this Microsoft SqlServer Desktop Edition is driving me nuts.. In particular the (lack of) documentation. I installed this tepid pos, then happily downloaded the appropriate SP3, and ran it.. SP3 rudely told me that the SA had no password and I had to assign it one (which I wanted to anyway), and mentioned something about a SAPWD switch. This is when the (not) fun part started. I could not find anyplace where to set the sa password.. Or any documentation on it. Perhaps I am just half blind, and stupid as well and not able to see it, but if anyone can tell me how, or where I can find the information I would highly appreciate it. /CMH
MSDE is a great database but it's not really sooted to active development work. If you have MSDN you should have the Developer Edition of SQL Server. This will give you all the GUIs to work with the database engine. MSDE only comes with OSQL.EXE which is a command line query tool. To change the sa password if OSQL.EXE is all you have connect to the database like so: 1. If MSDE is running in windows integration mode then you can connect like OSQL -E -S. 2. If MSDE is running in SQL Authentication the use OSQL -Usa -P -S. 3. Once you are connected you will be presented with the > prompt. Run the following to change the SA password sp_password NULL, "mynewpassword", 'sa' That is all.