.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

How can I hide the SQL instance from appearing in Enterprise Manager > connect > Network servers lis

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :Sql Server
 

I can find all sql instances in the network in Enterprise Manager > connect > Network servers list.

How can I hide my instances to appear in the list or in the network?


Sara


View Complete Post


More Related Resource Links

Outlook Unable to connect to MySite's "Social Network"

  
Running into a really odd issue. I have to farms configred pretty much identically, a production farm and a dev farm. For some reason I'm able to set up a social network connection from outlook to my dev farm without any problems but I get "invalid user name or password" when I try and connect tot he production farm. There's no errors showing in the SPLogs or the event viewer. I've checked everything I can think of but knowing me I'm missing something really small.

how can i connect to Access DB in another PC in network

  
Hello all ,  i want to make 2 separated programs that share database in network the Access DB is on PC and the program is on another one how can i make the connection between them ?Kareem Naguib

local pipes vs. network pipes (to connect to SQL Server)

  
Choosing a Network Protocol (SQL Server 2008 R2) tells: "It is also important to clarify if you are talking about local pipes or network pipes. If the server application is running locally on the computer that is running an instance of SQL Server, the local Named Pipes protocol is an option. Local named pipes runs in kernel mode and is very fast" Well, it is not me who is talking in cited article, I believe so. Should it be understood that "If the server application is running locally on the computer that is running an instance of SQL Server" and configuring/choosing Named Pipes mean running "local Named Pipes"?

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

Connect Analysis Server across network using ADOMD connection

  

Hi,

I'm new to Analysis Server. How will i connect the Remote Analysis Server across Network using ADOMD Connection.

 

Please Help me!


sunmoon_1411

Connect to server with other network credentials??

  

I work from home and need to connect to my employers database server. I am running SQL Server 2008 on my home PC and I am connected remotely to my employers network via vpn. However, if I try to make a connection via windows authentication it's using my credentials I use to log onto my PC and not the credentials I use to connect via vpn. How can I enter my vpn credentials and register the remote server in Server Management Studio?


Thank you...


When i connect SqlServer db i got The specified network name is no longer available.

  

 

Hi.

 i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.

 

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...

 

 


Unable to connect to sql server in network but working fine over VPN

  

Hi,

 

I have a sql server 2005 named instance running on windows 2003. I have an issue  in sql connectivity:

When the client system is in the network, client is not able to connect in management studio to the SQL server without specifiying the port number i.e. tcp: abc\xyz. If the client specifies the port number, he is able to connect to it like tcp:abc\xyz,20001.

Now the strange thing is : The same client system when connected over vpn works fine without specifying the port number in the connection string  like tcp: abc\xyz,20001.

then why is it failing to get the port number when the system is in the network?

I verified sql browser service. it is running fine. Firewall is in stopped state. What new components would come into picture over vpn that allow browser to service the port number? It's pretty strange issue and hence looking for any thoughts.

Note: SPN is not registered for the sql service.

-Praveen


Cannot connect to SSAS production server in customers network

  

Hi,

I have a problem when connecting to the SSAS production server (SQL Server 2008 Standard Edition) of my customer.

The situation is as follows: I have SSMS installed on my computer and also on the production server. On the server the connection to my SSAS/database works fine, but on my machine it doesn't. I am connected through a VPN connection with the customers network. The Windows Firewall is not activated on the Windows Server 2003 SP3 where SSAS is installed on. The connection to the SQL Server Database located on the same server from my machine works fine (via Windows Authentication), but as I said, the connection to SSAS does not. As we have different Windows Domains I am logged on with my corporate login (RCG\alexander.greiner) on my machine and connected through VPN with the administrative credentials (CUSTOMER\myadmin) I got from my customer.

Following error message is displayed when I try to connect to the remote SSAS in my customers network: "A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)"

Do you have any ideas on how I can solve this problem?

Regards,
Alex


Where's my Microsoft##SSEE? Can't connect, isn't in the Network Configuration, Doesn't show with

  

Hello.

I've been having various problems with Sharepoint etc since migrating from SBS2003 to SBS2008, but currently my problems all seem to be coming back to this one thing:

The Windows Internal Database (Microsoft##SSEE)

In the SQL Server Configuration Manager it's there under SQL Server 2005 Services.

It's NOT there when I look under SQL Server 2005 Network Configuration, and it's not there in portqry2 either.

I can connect to SBSMonitoring with Microsoft SQL Server Management Studio Express using Windows Authentication, but while I can select it from the "browse for more" list, I can't connect to the Microsoft##SSEE instance the same way. It gives me an error 26.

I am doing this from the server the instance is running on. Any ideas at all would be welcome.

 

Full details:

===================================

Cannot connect to fangio\MICROSOFT##SSEE.

===================================

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
<

how to connect remote sql server on non domain network using SQL Server authentication

  

Hai.

i m newbie on sqlserver.I had manage to build a database (MS SQL SERVER 2005 standard) with a vb.net 2008 and tested well with local machine. and wanted to put a software on client. and   some-how manage to stucture a security model on server authentication. but still not clear on user management. and others.

will anybody help me step by step how to connect remote sql server on non domain network using SQL Server authentication

 

Thanking you advance

 


Inaocha

connect to outside network domain

  

i have 20+ computers connecter to my 2008 server enterprise. on my server i have a domain which basicly gives rules to my local pc for bandwidth usage and such.

but what i want to set up is an assess point aprox 2 miles away from my office at a truck stop which will have its own internet connection. what i need is once my customers connect to this router there browser automaticly get brought up with a spash page agreeing to term and have my server control there bandwith usage. how would one go about this. i have the idea in my head but i cant seem to describe what im actually doing :)


SAAS: Connect Enterprise Apps with Hosted BizTalk Services

  

In this article we introduce you to BizTalk Services, new technology that offers the Enterprise Service Bus features of BizTalk Server as a hosted service.

Jon Flanders and Aaron Skonnard

MSDN Magazine June 2008


How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------


OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

  
Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

Could not connect using SQLDMO to SQL Instance ACQ01I

  
Hello, On mom I have an alert very frequent 13.000 times / in 30 days : "could not connect using SQLDMO to SQL Instance xxx". Is afecting only some clusters instances (normal servers are not beeing afected). I'm using mom 2005 ver 5.0.2911.0 and windows server 2003 sp2, sql server 2005 sp3. I have compared 2 instances : one with alert with other without the altert and I could see no difrences. DMO Looks well installed. - How to debug that DMO is working fine ? - How to change the dmo security ? - Why is afecting only some instances and not all ?

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

  
This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both 127.0.0.1 & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend