March 24, 2009 at 11:47 pm
Hi everyone,
I have a SQLServer 2005 DEVELOPER EDITION software and successfully i installed the server on one machine .Now i'm trying to install the client software on another machine.
I selected the "run clien wizard" from the installation main menu and assumeably installed a client on another machine. I try to run a client on that other machine but there is no "sql server" menu item at the window's "start" menu neither any such program on the disk.
I'd be grateful if anyone explains me how to install developer edition's client software on a machine other then the one with the server software and how i can run that client.
Thanks
March 25, 2009 at 3:20 am
First get this software SQLServer2005_SSMS ie Sql Server Management studio
Make sure you have enabled tcp/ip for sql server and port 1433 also enable local and remote connection in surface area configuration to using both TCP/IP and Named Pipes so that its possible to access the server remotly and localy .
And when you try to connect to the server using ssms if you are not able to connect using the instance name try using the ip address of the machine in which the server is installed.
Hopefully you have a network connection to the server and the services are started.
Tanx 😀
March 26, 2009 at 6:36 am
OK, this is what i did:
I selected "SQL SERVER Surface Area Configuration from "start" menu
At "Database engine" branch i clicked "remote connection" and signed:
"Local and remote connection"
"Using both TCP/IP and named pipes"
I turned to the other server which is configure the same as the first and clicked
"connect" and selected from "network servers" the remote server which i hade configured
as described above.
This is the error message i recieved:
"An error has occured while establishing a connection to the server...
may be caused by the fact that under the default settings SQL Server does not
allow remote connections."
Can i go foreward from this point ?
Thanks
March 26, 2009 at 8:35 am
To isolate SQL IS running
- connect from localhost ON the SQL machine if you can
Since you have enabled Remote Connection in SAC
Check the Configuration Manager -> Network Protocols -> see if TCP/IP is enabled
And please try the above suggestion = connect to SQL server using IP and PORT (not SERVER\INSTANCE), see if that works
March 26, 2009 at 9:09 am
Hi Jerry,
At "Server name" in "Connect to database engine" i assigned: 192.168.2.103 which is the ip i derived using: "run ipconfig".
I didn't find any place where i could enable port so i logged using only ip address and failed to connect to the desired remote.:crying:
March 26, 2009 at 9:17 am
I found the port enable item (called "via") and enabled port o:1433.
At the "server name" i only assigned ip and it didnt work. How do i assign port ?
March 26, 2009 at 3:52 pm
COnnect by specifying port and IP address in format:XXX.XX.XX.XXX,PPPP
MJ
March 26, 2009 at 10:02 pm
To set your listening port go to Sql Server Configuration Manager->Protocals for MSSQLSERVER
ON the right double click on tcp/ip and the select IP Addresses , then enter 1433 where ever you see TCP Port.
See to it that the SQL Browser services are started with Log on which is having the permissions to do it.
Tanx 😀
March 27, 2009 at 4:16 am
I'm into a new trouble now... cant connect the local server..
The service: "SQL SERVER MSSQLSERVER" is stopped. From right click menu i select: "start" and i get the following error message:"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". Any idea why i lost connection with the local server ? Where do i get that "event log" given i cant log into the server ?
March 27, 2009 at 4:24 am
In run type services.msc and start the sql server (MSSQLSERVER) make sure that this is set to Automatic. To avoid this problem in future.
See to It that all the sql server srvices needed to run your sql server in started
If you are not able to do that consult with ur in house system admin
Tanx 😀
March 27, 2009 at 4:49 am
I did it. It already is set to automatic. This is the error i get:
"The SQL Server (MSSQLSERVER) service on local Computer started and then stopped. Some services stop automatically if they have no work to do..."
If i install the sql server again would that erase existing databases?
I do not have administrator because this is a home network. I try to be my own administrator...
Thanks
March 27, 2009 at 5:04 am
No, it wont delete any database, you may have to reattach them once u install the sql server again.
i have just whole thread!!! r u trying to install client on your home system?
"Don't limit your challenges, challenge your limits"
March 27, 2009 at 5:15 am
initially i tried to install a client. I installed one but couldnt see any additional application in "start" menu nor any "exe" program on my disc to start it. So i installed another server (This is "Developer edition" i'm talking about) but couldnt log from the first server to the new one. I made all kinds of changes and experiments on both servers to find a way to log into the remote server and i failed to do so and now i cant log to my first native server where there are quite valuable databases.
Shoud i remove the server before i reinstall it or should i install it as is ?
Thanks,
March 27, 2009 at 5:25 am
If you have any problem in your local system then you do not have to reinstall sql on remote server. Just for sure, take back up of 'data' folder (containing all .mdf/.ldf) Or all your database files before reinstalling the server.
BTW, i have some confusion...
1) there are two systems, remote machine with sql server admin console, and local machine with sql server client. right?
2) you cannot connect from client to server, right?
if yes, are your both machines in same domain?
"Don't limit your challenges, challenge your limits"
March 27, 2009 at 6:00 am
I'm at the course of reinstalling my first sql server and i have to make a choice between 2 selctions, a choice which might be the reason for all the troubles:
1."use the built-in system account" : that is the previous choice i made at the old installation
2. "use a domain user account". If this is the selction i should choose, which domain name i have to provide ? should i just invent a domain name or should i provide an existing domain name ? My network does not have any domain name.
Your help in that point might be important.
Thanks
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply