Sql

[OuTCasT]

Please can someone tell me the standard username and password for SQL
i know that it is something "sa" but cant remember exactly.
ive created a windows application and now want to deploy it, ive added the databse to the project and the connectionstrin g to it, when i try insert data it says "not a trusted sql".

where can i change username and password to the database ?

[ck9663]

Please can someone tell me the standard username and password for SQL
i know that it is something "sa" but cant remember exactly.
ive created a windows application and now want to deploy it, ive added the databse to the project and the connectionstrin g to it, when i try insert data it says "not a trusted sql".

where can i change username and password to the database ?

there are 2 basic ways to connect to sql server. using your domain (LAN) username/password or using a local account created in sql server. during installation, dba's set the type of authentication that sql server will be using. it can be changed even if it's already installed. your connectionstrin g is trying to connect using the domain username/password. your error says you can not connect using that method. it's either that your sql server only accept local accounts or your driver does not allow trusted connection (using domain accounts) or it could be simple as you're passing an incorrect parameter on your connectionstrin g.

check this out

by the way, to answer your question, sql server usually have the sa account. you just have to figure out the password

-- ck

[OuTCasT]

there are 2 basic ways to connect to sql server. using your domain (LAN) username/password or using a local account created in sql server. during installation, dba's set the type of authentication that sql server will be using. it can be changed even if it's already installed. your connectionstrin g is trying to connect using the domain username/password. your error says you can not connect using that method. it's either that your sql server only accept local accounts or your driver does not allow trusted connection (using domain accounts) or it could be simple as you're passing an incorrect parameter on your connectionstrin g.

check this out

by the way, to answer your question, sql server usually have the sa account. you just have to figure out the password

-- ck

The connectionstrin g to my database was

Data Source=DONOVANLAP\SQLEXPRESS;Initial Catalog=ca2000;Integrated Security=True

then i added the database to the project then i changed it to

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\Donovan\Documents\Visual Studio 2005\Projects\Ca2000WINversion\Ca2000WINversion\CA2000.mdf";Integrated Security=True;User Instance=True

that is the connectionstrin g that it gives me. "login failed:trusted user"
now if i want to deploy it does the client need sql expres on his pc or can i add the database to the project like i have done and jst use the connectionstrin g to it like i have done, then will it read/write to the db ??

[ck9663]

The connectionstrin g to my database was

Data Source=DONOVANLAP\SQLEXPRESS;Initial Catalog=ca2000;Integrated Security=True

then i added the database to the project then i changed it to

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\Donovan\Documents\Visual Studio 2005\Projects\Ca2000WINversion\Ca2000WINversion\CA2000.mdf";Integrated Security=True;User Instance=True

that is the connectionstrin g that it gives me. "login failed:trusted user"
now if i want to deploy it does the client need sql expres on his pc or can i add the database to the project like i have done and jst use the connectionstrin g to it like i have done, then will it read/write to the db ??

what kind of application are you using? how are you deploying this?

-- CK

[OuTCasT]

what kind of application are you using? how are you deploying this?

-- CK

A windows based application.
all it does it insert students. products etc and .csv files.

it got a database called ca2000.mdf
i want to just install it on any client and it mst save data to that database.
i tested it on another pc but had to have sqlExpress and change the connectionstrin g to the sqlExpress server of the pc.

[OuTCasT]

oh and im using visual studio to publish the app...
i want it to work independently from sql server, jst writing to the db that is included in the application....

[ck9663]

am not sure about express. i think there are limitations with the express version...you might need to have it also installed on the same machine...or you can put it on the server and deploy your application as shared app...maybe a browser-based

-- CK