Board index MS SQL Server

How To Create Database, UID, PWD

How To Create Database, UID, PWD

Post by hchu » Wed, 15 Apr 1998 04:00:00



I have a simple question, but seems difficult to me:

I just installed SQL/Server 6.5 Evaluation Copy on one NT 4.0. My purpose
is to create a database on the server and set a ODBC DSN poniting to this
database on another machine of the LAN, so that I can test an application
which will create all the tables. I started the service, and from SEM click
Manage->database... But error message: " A connection could not be
established to SERVERName -[SQL Server] Login failed".   My questions are :
1. How to create a empty database on the server? 2. How to set  the
opetions for the DSN on the other machine?.
By the way, I used all the default during install by running
/I386/setup.exe

Thank you very much for any help.

--Huaping

 
 
 
Top

How To Create Database, UID, PWD

Post by Gianluca Hot » Thu, 16 Apr 1998 04:00:00



> I have a simple question, but seems difficult to me:

> I just installed SQL/Server 6.5 Evaluation Copy on one NT 4.0. My purpose
> is to create a database on the server and set a ODBC DSN poniting to this
> database on another machine of the LAN, so that I can test an application
> which will create all the tables. I started the service, and from SEM click
> Manage->database... But error message: " A connection could not be
> established to SERVERName -[SQL Server] Login failed".   My questions are :
> 1. How to create a empty database on the server? 2. How to set  the
> opetions for the DSN on the other machine?.
> By the way, I used all the default during install by running
> /I386/setup.exe

Try re-registering the server in SEM. If you used defaults during
installation then you should specify "sa" and blank password for
SEM to login to the server.

Best regards,

--
Gianluca Hotz                                __
Tecnical Service Manager at Alphasys srl    /  \/ /
Microsoft MCP (Windows) MVP (SQL Server)   / /\/ /
Currently working for Ekar spa             \ \/ /\
http://ghotz.home.ml.org                    \__/\ \
--

 
 
 
Top

1. save UID and PWD when creating user DSN

Anyone knows how to create/Add a DSN saving the user and password. I would
like to "simulate" what the ODBC admin does when creating a user DSN with
the SQL Server driver, allowing me to save the user id and password for a
non-trusted connection (using . SQL Server Authentication )

I can successfully create the DSN calling SQLConfigDataSource(NULL,
ODBC_ADD_DSN, szDriverName, szAttributes); but if I add in the attributes
"UID=MyID\0PWD=MyPass\0", it fails. I know I can pass this info when I
connect but all I need is to add the DSN.

thanks for any tips,
Claudio

2. Sql Profiler Duration is null; any idea why?

3. Can not programatically create DSN with UID and PWD

4. ORA-01991 error?

5. Open database without UID and PWD!!

6. Using ODS

7. How to open secured database through ODBC without sending UID and PWD in connection string

8. SQL Server and NTSP4

9. How to connect database without UID & PWD

10. Hide UID & PWD in ADP connection

11. System DSN question how to avoid hardcoding a UID and PWD into connection string

12. SQL Server UID & PWD

13. Saving UID and PWD for ODBC connection


All times are UTC
Board index