SQL Server - Client access
Asked By Mirco Kaminski
10-Aug-09 06:09 AM
Hi NG,
I can not access by my client on the MSDE host .
OSQL -S SERVER4\INST2 -U sa -P PASSWORD -d OPDATAS -Q "SELECT TOP 10 ADRESS
FROM ADRESSES"
In addition, I no longer see the server name (\ INST2)
The standard SQL Server is visible.
Are new settings to take into consideration?
Thanks for all tips
Mirco
SQL Server
(1)
RunsGreatingsMirco
(1)
Directory
(1)
Greatings
(1)
Lab
(1)
OPDATAS
(1)
OSQL
(1)
Richard Mueller [MVP] replied...
Possibly the TCP/IP protocol is not enabled.
In Enterprise Manager select the instance, right click and select
properties, then on the "General" tab click "Network Configuration" and make
sure the TCP/IP protocol is enabled.
--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--
Mirco Kaminski replied...
thanks, it runs
Greatings
Mirco
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit seconds left to the installation and bombed with the same errors as the Crystal Reports Server install. The error is the same whether I try to install MSDE by itself or
Why_can’t_recursive_queries_contain. . .? SQL Server hi I hope I didn = 92t put too many questions 1) Why can = 92t recursive queries also be unioned together with UNION operator ( instead they must use UNION ALL )? thanx SQL Server Programming Discussions SQL Server 2008 (1) SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) Oracle (1) Ruby (1) MichaelcoAToptonlineDOTnet (1
SQL Express: Failed Reinstall SQL Server Dear Setup Experts: I am trying to reinstall SQL Express after playing with it some. I uninstalled it, and now, it refuses to reinstall in the face. Any ideas what this log file means and how I can get SQL Express installed? I really do not want to have to reinstall my whole system. * ** ** Start of Log File Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203
Changed server NIC and IP address; can't connect to sql server SQL Server I changed the nic on a sql server 2008 server and gave the server a new ip address. The server has access to the LAN
sql server tutorial SQL Server I dled the c# samples from msdn Tried to run the create database sample (connects to sql server) the docs says visual studio required. . .i only have express is there no way to express is not going to run the sample? 2009-11-24 18:32:46.95 Server SQL Server is now ready for client connections. This is an informational message; no user action