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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

can only connect to instance via port number

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
I can connect to an instance by specifying the port but not by the instance name. Becuase of this, no replication is occuring. Please see porqry and sqlcmd output below ...   d:\>portqry -n MDLEXPSV02 -p udp -e 1434 Querying target system called:  MDLEXPSV02 Attempting to resolve name to IP address... Name resolved to querying... UDP port 1434 (ms-sql-m service): LISTENING or FILTERED Sending SQL Server query to UDP port 1434... Server's response: ServerName MDLEXPSV02 InstanceName SQLEXPRESS IsClustered No Version 9.00.4035.00 tcp 1184 np \\MDLEXPSV02\pipe\MSSQL$SQLEXPRESS\sql\query      ?  ?P'   % ==== End of SQL Server query response ==== UDP port 1434 is LISTENING d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS -P sapwd HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not  allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired. d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS,1184 -P sapwd 1> exit d:\>

View Complete Post

More Related Resource Links

Specify Instance Port Number on Command Line Install

Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips

IIS - sharepoint/default website port number confusion



I have MOSS 2007 installed with IIS V7.

My default web site port is 80. When I created a new web application for my main sharepoint portal I also set it to 80. So obviously now the default web site port shows as stopped in IIS and it won't start.

What are the best practices. Should I change the port number for my portal to something else? I mean is it even a good idea to have sharepoint on port 80? If so, how do I go about changing the port number for my portal site?

any help appreciated.

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)

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 ?

Problem with MOM using DMO to connect to SQL 2000 instance

Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Ping IpAddress with Port number?

I am using System.Net.NetworkInformation with Ping method.   But it seems like it can only ping IPAddress. What should I need to do if I need to find out whether a port of the IPaddress is available?   Let me know. I will reward you.   Thanks

Visual studio 2005 - Port Number is difference during run time.

Hi, When I debug(F5), the port number display in the URL is difference from the ASP.net development server. Eg: URL address port number is  - 1084, while for the Server is 1088 I have tried difference ways such as trying to set the dynamic port to false, so that I can configure my own port, but it is not able to work. I have also turned off the ESet Firewall however the port number is still difference.  Need your help in this area.. Thank you! 

Use Report Builder 3.0 with SharePoint site using a port number

We are currently working with SSRS R2 and SharePoint 2010.  SharePoint 2010 has been deployed a multitenant solution.  SharePoint and SSRS are on separate servers.  We have successfully integrated the two products but are experiencing some anomolies.  The SharePoint site we are deploying to uses a port number (e.g. http://mysharepointsvr:2222).  When you launch Report Builder from this site, it does not open connected to a Report Server.  When you try to connect to a Report Server the obvious choice is to put in http://mysharepointsvr:2222 for the Report Server service.  However, this does not work.  We are getting the following error: Connection Failed.  Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'.  Make sure the server is running, the URL is correct, and you have permission to use the server. However, if we use the SharePoint address without the port number it will connect.  This does not work as the SharePoint port determines which site we are directed to for resources.  In our case, we need to be able to browse the folders on port 2222 not port 80 (default).  As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites.  In all cases, identical credentials are being u

Cannot connect to Sql Server Local Instance

Hello allI just installed sql server 2005 to my pc and when i try to log in to the server instance i get an error log in failed for user xxx (error 18456). I browse to the server instance and i keep getting the same error even though i chose windows authentication option during the installation. I restarted the service for the sql server instance (which is running).The only problem i can think about is a problem with permissions but again there should not be any problem there because i logged in as administrator. Any suggestions please!!!

bdc - unable to connect to instance

CAN SOMEONE HELP ME PLEASE??? Here is my scenerio, - only one SSP... 1. Central Admin: Integrated Windows Authentication - Negotiate Kerboros 2. ADF file: <LobSystemInstances>     <LobSystemInstance Name="requestforchanges_Instance">       <Properties>         <Property Name="rdbconnectionData Source" Type="System.String">xxxxxx</Property>         <Property Name="rdbconnectionInitial Catalog" Type="System.String">xxxxxxx</Property>         <Property Name="rdbconnectionIntegrated Security" Type="System.String">True</Property>         <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>         <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>       </Properties>     </LobSystemInstance>   </LobSystemInstances> ..... 3. Using Admin a

Public URL Port Number appended for WebTaggingDialog.aspx page

Hi, I am not sure if this the right place to ask this question, We have a SarePoint site exposed to internet which has a web application at 8081 port. There server is behind a firewall which proxying 80 port network to 8081 port of SharePoint server. All Pages, Content and Images are working perfect but only the pages related to Taxonomy Store has port number appended to url which is not accepted at the firewal for example if the http://abc:8081 is my site the internet url is http://sharepoint.com all this is working but if is open page with WebTaggingControl or List with taxonomy fields the url http://sharepoint.com to going out of the browser as http://sharepoint.com:8081 so the firewall is blocking. Also I am not sure if the firewall can listen at two difference ports 80 and 8081 for a same url If this is not the right forum please redirect me to a forum where I could get help on this Thanks for taking time Deepak  

Sharepoint site by something other than computer name: port number


I am quite new to sharepoint and like what I see so far, but I am having major problems getting a site by a domain other than http://computername:portnumberto work for me.

For example.  Lets say my computer name is sharepoint server and I want to create a web application and collection by the name of mysite.mysite.com.  The mysite.mysite.com site creates fine and shows up in IIS fine.  I create a host file entry for mysite.mysite.com and point it to my server.  When I try and browse to the site http://mysite.mysite.com I get challenged for authentication.  If I ping the site it is pinging the correct server. I put in the correct username and password, but I am unable to login.  If I create a site that is just the computer name and a random port number I am able to log in.

I figure I am missing something simple, but I have tried to research this for several hours and have gotten no where. Can anyone point me in the right direction?

I would also like to add that I would like to make serveral sites that are running over port 80 by using host headers...if that changes anything.

Port number is alredy in use


I try to run my first web application with Web Matrix. When I try to start the application and choose a port number (Application Port), I get the following message:
The specified port number is alredy in use. I have tried with port numbers 80, 8080 and 8088. What is wrong?

Sincerely, Albert.

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.


how to write SMO's conn.ConnectionString with IP address and port?

"Connect to Outlook" and "Open Schedule" disabled in Ribbon on instance of Project Tasks list


Hi Everyone,
I am creating a custom list template for "Project Tasks", essentially I need a customized version of the OOB Project Tasks list. I've cloned the OOB feature over to my Visual Studio 2010 solution and I am able to successfully deploy my version as expected, with everything fully functional, gantt chart and everything, except one thing. When I provision an instance of the list using the OOB list template, I am able to see everything in the Ribbon enabled. However, when I provision an instance of my custom list template (clone), I see the "Connect to Outlook" button disabled, as well as the "Open Schedule" button disabled - which allows you to open the task list with Microsoft Project (I have all Office 2010 clients installed, including Microsoft Project).

I am guessing there must be some type of setting somewhere that associates the OOB list template to those Ribbon items that I see as disabled. The only thing different between my list template and the OOB list template is the Type ID. Could this be the problem?

Where should I be looking to troubleshoot this issue?


Why is Sharepiont appending port number to public URL?


I have created an extended web application, so there are two SharePoint applications running on the same server, one on port 80 and the other on port 8081.  Internally everything is fine.

In the extended application I installed the "Help Desk" template.

When I try to access the extended application using the public URL, everything is fine initially, I can browse from site to site, I can browse service requests and other lists, but as soon as I try to access folders that I have created in the "Knowledge Base" SharePoint begins to append port 8081 to the public URL.  For example, let's say that my public URL is www.knowledgebase.com, SharePoint begins to reference www.knowledgebase.com:8081.  Obviously this is not going to work, NAT will not allow it.

I can view documents in the root of the Knowledge Base, and I can upload documents to the root of the Knowledge Base, but as soon as I try to access a sub folder, the URL is wrong because SharePoint is appending the port number and the URL can not be resolved.

I can not find anywhere in the configuration where I have asked SharePoint to do this for me.  What is going on?  This has to be something simple, but I can't seem to track it down, any suggestions would be greatly appreciated.

Also, I am not having this trouble in the application running on

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