Did you try the link I posted in my last post? It gives instructions on how to change the authentication mode. It's a registry hack. But if you follow the instructions, shouldn't have a problem.
Did you try the link I posted in my last post? It gives instructions on how to change the authentication mode. It's a registry hack. But if you follow the instructions, shouldn't have a problem.
"The best software is the one that fits your needs." - A_A
Virus free since: date unknown
Anti-virus free since: August 2008
Any luck DK?
"The best software is the one that fits your needs." - A_A
Virus free since: date unknown
Anti-virus free since: August 2008
oh yeh sorry for the delayed reply. um yeh i got it to work but it still failed in the long run saying
from that message i'm guessing i actually got the mixed mode authentifcation because it no longer dismeses the sa account it just wont open the dbase that i created with ems mssql manager.Code:Cannot open database requested in login ' temp'. Login fails
A related problem :
How do I install a new user and password to MSDE? (Is this a good idea in general, to add more users?)
How do I view all users and passwords that are allowed on all databases?
Last edited by crosswire; Jun 29, 2005 at 07:01 PM.
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
OK I read up on the article provided by AA. Thanks
http://support.microsoft.com/default...22120121120120
and I went to Run and type command, then
osql -?
for help info
osql -E -S M3\NetSDK
to login in trusted connection, then
sp_password @old = null, @new = 'sapwd', @loginame ='sa'
go
to change password, still have to log in as trusted afterwards though so I did log in again and typed
EXEC sp_helplogins
go
Got some usernames, now only to get their passwords
sp_helplogins
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
OK I think I need to read up the authentication but I think I got it to work, ie logon to a database, I only use the Trusted connection so far and I do not think this is the right method, but anyway
osql -E -d Northwind -S M3\NetSDK
using a database name Northwind given from sp_helplogins
Select * from Customers
go
Selecting a table and something happens
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
I did the registry hack and got mine to work with the password
@DK
Yours should work too, the proceedure is correct. The problem is that login name that you used is not a member for the database that you want to access.
I am not good with the password thing yet being new to SQL, unlike you all. There are databases that are accessible by all users, or some users (I wonder if its is by user groups). Users that access a database are given certain permissions in that database. So you need to add that user name to the database.
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
Here is a detailed proceedure I used, for any reference
The explainations need to be updated as I learn more SQL
================================================== =================
With a fresh boot with HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\NetSDK\MSSQLServer LoginMode=1
Run
You are now in admin space if you see "1>", so add new userCode:osql -E -S M3\NetSDK
Check the users that are presentCode:EXEC sp_addlogin 'cw', 'cwpsd', 'Northwind', 'us_english' go
Now change the registry key above to LoginMode=0Code:sp_helplogins go
Restart computer
Now type
At the 1> prompt, type your sql statementCode:osql -U cw -P cwpsd -S M3\NetSDK -d Northwind
This user, just created, has access to some databases like pubs and Northwind, and some stored proceedures that do not access all databases unlike sa or a trusted connection user.Code:select * from customers go
To see accessible databases, type sp_helpdb
Now login as the saCode:exit
Type this again to see the login usersCode:osql -U sa -P sapwd -S M3\NetSDK
Use the sa to change the role of cw to a db_owner in a database.Code:sp_helplogins
Check the VS.Net Help Collection for the T-SQL references used aboveCode:use Northwind go sp_adduser 'cw', 'cw', 'db_owner' go sp_helplogins
================================================== =================Code:exit
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
Hey DK! have you finished ASP.net
I found this good article on web services and want to post it but don't know where, so I think I would append it here.
(choose a link)WebServiceUtil.exe allows us to name a SDL, or contract, as one of the command line arguments and the tool can then generate the source code for a proxy to our Web Service.
http://msdn.microsoft.com/library/en...asp?frame=true
http://msdn.microsoft.com/library/de...sp02222001.asp
http://ms-help://MS.VSCC/MS.MSDNVS/d...sp02222001.htm
Last edited by crosswire; Sep 1, 2005 at 04:28 AM.
Let's act on what we agree on now, and argue later on what we don't.
Black men leave Barbeque alone if Barbeque don't trouble you
I don't know about that. I did six weeks rigorous php and i found it pretty inept. eg. on a application with, say, 20 lines of code: "Fatal error on line 85!"Originally Posted by death_knight
Don't know if they fixed that 'bug' yet...?
The fox was probably right - they could have been sour grapes.