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 |
|
JacobPressures
Posting Yak Master
112 Posts |
 Posted - 2005-10-12 : 12:47:49
|
| Hi, I have an application in visual basic. I'm going to use two laptops at the moment to do a demonstration. What i need to know is how to let my program know where the database is. I had SQL Server running on my laptop. What i want to do is set up the application on another computer using a simple network (using crossover cables?) to connect to my laptop to create a client/server environment for the demo. So that is two laptops, the SQL Server 2000 on my laptop and the application installed on another computer which is networked to my computer.Right now I'm using the following connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FAE;Data Source=KMSServerBut if the server is on another computer i don't see how it will know to go there on its own. Previously in MS Access, i had to provide a path. If i install the app on another laptop i'm sure it will not magically know that the SQL Server 2000 DB is actually stored on another machine.The above connection string works fine as long as the app and server are stored locally on the same machine.One other question is Windows Integration Security. Will the app even be able to talk to the server on my computer?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-12 : 13:13:49
|
| You just need to add an alias on the client machine using Client Network Utility. The alias would be named KMSServer. Then either use the hostname of the db server or its IP Address in the server name field. Make sure to specify the correct port in the alias.About Integrated Security, that depends if the Windows user has access to everything it needs in the db server. I guess you won't be in a domain, so you'd have to create that same userid and password on the db server as a local user in order for this to work. It might be easier just to use SQL Authentication.Tara |
 |
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-10-20 : 17:46:05
|
| The guy i used to network my computers assigned an IP Address. Shared my hard drive and made a connection between my computer and the other computer.In the connection string i guess i refer to the Hard Drive name where i put the server name, KMSServer?Is that all i have to do? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-20 : 17:48:35
|
| You can't connect to SQL Server via a hard drive or even a share. You must use the IP address, hostname, or alias of the database server.Tara |
|
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-10-21 : 09:37:44
|
| so is sharing the drive not required? What is a hostname? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-21 : 12:15:05
|
| Hostname is the command that you can run from a cmd window to find out what the machine name is. Sharing a drive is not required to connect to a SQL Server.Tara |
|
|
|
|
|
|
Use Laptop for Client/Server Demo