Showing posts with label registration. Show all posts
Showing posts with label registration. Show all posts

Friday, March 30, 2012

I encountered problem after .NET framework upgraded to 2.0 in the server

I posted the question below to this website 6 hours ago, the subject was "SQL server registration failed". I couldn't find this question just now. This is my first time to post a question to microsoft website. Please let me know the related website if the question shouldn't be posted here.(I think it 's related to this site)
URGENT, I need help, thanks.

I installed .Net framework 2.0 in a Window 2003 Server and VS2005 in my PC a few days ago (.NET framework 1.1 is still in the server and VS.NET2003 is still in my PC), SQL server 2000 is with web server together. there is no problem to run ASP.net 2.0 application, the application also can query the database in SQL server.
But I encounter a problem that I can't create new SQL server registration from my PC to the above server. the error msg is "SQL Server registration failed. SQL Server does not exist or access denied ConnectionOpen(Connect())"
There is no problem to connect SQL server remotely before I upgraded .net framework to 2.0 and VS.NET2003 to VS2005.
I checked the SQL service (started), TCP/IP(enabled). I also installed SQL server SP4 in the server, but I still encounter the same problem.
Anybody can help? Thanks


moving to SQL forum.

|||I guess the firewall on the Windows 2003 server doesn′t allow incoming communication on port 1433. Change that and as a stateful firewall Windows will open the outgoing ports for communication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Friday, March 23, 2012

I cant make new SQL Server Registration

When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.

cheers
gola munjal

Originally posted by yajai
When I regratrate, it occurs that

"SQL Server do not exist or access denied
ConnectionOpen(Connect())"

Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is

Pinging 216.58.174.179 with 32 bytes of data:

Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.

Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.

Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.

Wednesday, March 21, 2012

I can't add a new Reporting Services server registration of a remote server.

I need a help.

This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.

Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.

From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.

On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!

Is this a systemistic, configuration issue? Some advice to solve it?

Thank you in advance.
Marina B.

So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||

Hi,
thank you for the answer.

Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...

At the end I was able to solve the problem enabling the SQL server Agent and Browser!!

Thank you

Marina B.

sql