sql server connection

Hot Topic

ERR: 18483 , 'distributor_admin' not defined as remote login.
Keep package alive forever
Conflicting docs on how to render
Dynamic columns in report
Strange results when using parent child dimension
Retrieving Hierarchy Captions from a Cellset
Time Dimension
Using Management Studio to manage .sdf file on device
Design Question - Is Integration Services the way to go ??
Error Creating DSN using odbcconf.exe for SQL Server

SQL Server

Make the series stand by themselves in stacked column graph
SQL Server Express Edition silently at command prompt
ssis bulk insert task
linked server: Error 17: SQL Server does not exist or access denied.
keep together table groups
Reporting Services Data Source Types
Test\Prod databases on same server; same SSIS algorithm but different connection strings needed
Replacing Oracle sequencers
Custom Paper Size
Distribute Print ActiveX control to masses

sql server connection

hello,

before i'm using vb-access, now i would like to shift to vb8-sql server. i have here sql server express. i can make a connection with them but when i run my application to another pc, i cannot install it and i don't know if my connection will be working. i'm using a peer-to peer networking. please bear with me, this is my first time to do this stuff. can somebody explain it to me please thanks

Answer this question

sql server connection

  • laboremus

    Take a look at the following blog post for configuring SQL Server Express to accept remote connections: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

    Cheers,
    Dan



  • Tom_Liu

    sir i followed the suggestion on your link, but i still cant get my data to work in network. heres my config now.

    on Protocols For SQL Express, i have my TCP/IP only enabled all others are disabled. i followed the suggestion to what to do inside the properties.

    on my SQL SERVER 2005 SERVICE on my SQL SERVER(SQLEXPRESS) properties, on the Log-On Tab i use Built-In Account- Network Service, and on the Service Tab i make the Start Mode- AUtomatic.


    any more help sir thanks

  • Steve Huckett

    Sir,

    Thanks for you reply. if i use SQL Server Authentication, I cannot make a connection, I think when I install VS I didn't put any user name and password. heres my connection string

    DataSource=.\SQLEXPRESS;AttachDbFilename=D:\database\database\inventory.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

    Any more help sir, thank you.

  • rodniko

    You said you're doing peer-to-peer networking. I recommend you use SQL Server Authentication for this to make it a bit more simple. Then, on your connection string, specify "Data Source=computername\SQLEXPRESS;Initial Catalog=sample_database;uid=name;pwd=password;"

  • PIBO

    DataSource=.\SQLEXPRESS
    Dot means local machine. If you'd like to connect server located on another machine, specify either ip-address or machine name insted of a dot (that's depending of what protocol your server configured to work with, if any network protocol specified at all).
  • sql server connection
Answer this question