How to create user 'sa' on Sql Server
-
hello guys... I wrote an application inwhich I use the user 'sa' to do some small transactions, in Sql Server. Now when I run same program on some other computer, this programs shows some debug error saying
Debug Error !
This application has requested the Runtime to terminate in its unusual way. Please contact the applications support team for more information.Now since I have run this small EXE on my laptop, so I know nothing is wrong with my program. There got to be something wrong with my user creation. So how to create user 'sa' properly...thnx
-
hello guys... I wrote an application inwhich I use the user 'sa' to do some small transactions, in Sql Server. Now when I run same program on some other computer, this programs shows some debug error saying
Debug Error !
This application has requested the Runtime to terminate in its unusual way. Please contact the applications support team for more information.Now since I have run this small EXE on my laptop, so I know nothing is wrong with my program. There got to be something wrong with my user creation. So how to create user 'sa' properly...thnx
Hi, You don't create
sauser.sais created byt the SQL Server when you choose mixed security mode during the installation or later via instance properties. Sosais a special user defined when SQL Server authentication is enabled, kind like administrator in windows. [Added] To change the authentication mode, for example: http://msdn.microsoft.com/en-us/library/ms188670.aspx[^]The need to optimize rises from a bad design.My articles[^]
modified on Saturday, March 12, 2011 12:44 PM
-
hello guys... I wrote an application inwhich I use the user 'sa' to do some small transactions, in Sql Server. Now when I run same program on some other computer, this programs shows some debug error saying
Debug Error !
This application has requested the Runtime to terminate in its unusual way. Please contact the applications support team for more information.Now since I have run this small EXE on my laptop, so I know nothing is wrong with my program. There got to be something wrong with my user creation. So how to create user 'sa' properly...thnx
overloaded Name wrote:
There got to be something wrong with my user creation
I suppose that is possible if 1. Your wrote your program in C/C++ 2. You have a bug (or several) in your code. Supposing that the first is true then when you attempt to interact with the database you will get error information back (if your code doesn't have bugs.) So reporting that information is useful. And if that error is such that the app can no longer proceed then the application should gracefully exit.