sql server connection string

[simflex]

Hello all,
We use sql server db and we set it up with the following:
authentication: mixed mode Isql server and windows)
account: domain account.
And we use the following connection string to try to connect to the database.
It isn't connecting, can someone please tell me why?
emailDB.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=safety;Data Source=pt2.

Here is the error:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Cannot open database requested in login 'safety'. Login fails.

[edoc]

Try this link for connection string examples:

www.able-consulting.com/ADO_Conn.htm (http://www.able-consulting.com/ADO_Conn.htm)

Are you connecting over the internet/intranet?

edoc