Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yshie
Starting Member
28 Posts |
 Posted - 2007-03-30 : 00:27:32
|
| ok.. i'll start from a scratch! kindly help me build my connection string! pls don't refer me to different websites because i can't understand those terms(user instance... etc) so its useless for me. all i know is that i have this visual studio 2005 and isn't it that inside there is ms sql server where i created my database. what connection string will i use? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-30 : 00:31:19
|
| If you cannot figure it out from here, then it's unlikely that you can give us the information we'd need to be able to help you any furtherhttp://www.connectionstrings.com/?carrier=sqlserver2005 |
 |
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-30 : 00:47:43
|
| for the standard security...where will i get those username and password? |
|
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-30 : 02:30:55
|
| i'm creating a windows application.i have this connection string...Data Source=(local);Initial Catalog=PEdb;Integrated Security=SSPI;but i got this error...An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)i don't know what remote connection means. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-30 : 03:55:19
|
| Firstly we need to know what edition of sql 2005 you are using? Is it Developer edition? Express edition which is installed along with VS 2005?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-30 : 08:21:18
|
| it is developer edition |
|
|
|
yshie
Starting Member
28 Posts |
Posted - 2007-03-31 : 03:45:05
|
| i got it now! tnx |
|
|
|
|
|
|
connection string