Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft SQL Server
Reload this Page

How to change the COMPUTER NAME in SQL Server 2000 manager???

Discuss How to change the COMPUTER NAME in SQL Server 2000 manager??? in the Microsoft SQL Server forum on ASP Free.
How to change the COMPUTER NAME in SQL Server 2000 manager??? Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old February 14th, 2004, 02:28 AM
Andrew2004 Andrew2004 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 9 Andrew2004 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question How to change the COMPUTER NAME in SQL Server 2000 manager???
Hi

PLEASE, I really need help. I have installed SQL Server 2000 Developer version on my Windows XP Professional. After I ran the "Enterprise Manager", under the "SQL Server Group", it must be my COMPUTER NAME (ie. andrew), but unfortunately, it is "local" (Below is the diagram). My question is how can I change it to my COMPUTER NAME? Since my ASP.NET page can't connect to the SQL Server 2000 database. I have followed the instruction from this web page, http://www.stardeveloper.com/articl...02041001&page=1

I am very appreciative for any help.
Attached Images
File Type: jpg corel.jpg (63.2 KB, 522 views)
Last edited by Andrew2004 : February 14th, 2004 at 02:31 AM.
Reply With Quote
  #2  
Old February 14th, 2004, 09:55 AM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 28 m 48 sec
Reputation Power: 180
Try creating an alias with the client network utility

Although your code should be able to connect via IP or computername from the local computer anyway.
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #3  
Old February 14th, 2004, 11:55 AM
Andrew2004 Andrew2004 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 9 Andrew2004 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thank you Doug G. Is there anyway that I can change its name to my computername? I don't want to make alias. Since I have checked the icon in the taskbar of the SQL Server 2000, it is assigned with my computer name, "Pentium4_2400". You can see the below attached diagram.
Attached Images
File Type: jpg corel.jpg (25.5 KB, 596 views)
Last edited by Andrew2004 : February 14th, 2004 at 11:57 AM.
Reply With Quote
  #4  
Old February 14th, 2004, 03:00 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 28 m 48 sec
Reputation Power: 180
You could try deleting the current server registration in EM and re-registering your server using the computer name.

Unless you installed a named instance of sql server, the sql server will inherit the computer's name, but in various screens it will be listed as local. This has never been a problem for me.
Reply With Quote
  #5  
Old February 14th, 2004, 04:12 PM
Andrew2004 Andrew2004 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 9 Andrew2004 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thank you Doug G. Since I am new to ASP.NET and SQL Server 2000 so I just follow the tutorial from the website that I provided the link before, but my code could not connect to the SQL database.

Below is one of my OTHER code that I have tried to connect to the Northwind database with the SQL Server 2000, but it gave me an error. I think that the "connection string" of the code below is not right to connect to the SQL Server 2000. So could you PLEASE correct the connection string and test on your system to see if it works or not? I am very appreciative for your help.

----------- SQLServer_connection.aspx ---------------

<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

<html>
<head>
<title>Beginning ASP.NET Databases Chapter 3</title>
</head>

<body>
<h4>First Example: Listing data from the Employees table</h4>
<asp: DataGrid id="dgNameList"
runat="server"
GridLines="None"
BackColor="LightBlue"
CellPadding="5"
CellSpacing="5"
BorderWidth="2"
BorderColor="Black"
ToolTip="Includes only those employees who are at HQ" />
</body>
</html>

<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
Dim strConnection As String = "server=(local)\NetSDK; database= Northwind; " & _
"integrated security=true;"
Dim objConnection As New SqlConnection(strConnection)

Dim strSQL As String = "SELECT FirstName, LastName, Country " & _
"FROM Employees"
Dim objCommand As New SqlCommand(strSQL, objConnection)

objConnection.Open()
dgNameList.DataSource = objCommand.ExecuteReader()
dgNameList.DataBind()
objConnection.Close()
End Sub
</script>
Reply With Quote
  #6  
Old February 14th, 2004, 08:38 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 28 m 48 sec
Reputation Power: 180
Take a look here, I'm sure it will help you get connected

http://www.able-consulting.com/ADO_Conn.htm
Reply With Quote
  #7  
Old February 15th, 2004, 11:14 AM
Andrew2004 Andrew2004 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 9 Andrew2004 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thank you
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft SQL Server > How to change the COMPUTER NAME in SQL Server 2000 manager???

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway.