Solved

SQL Server naming issue

Posted on 1998-06-22
2
175 Views
Last Modified: 2010-03-19
We are required to install SQL 6.5 by Mcafee ZAC suite...our problem is that we were flagged upon installation of SQL that we must rename our server...that is not going to happen...we know there is a way to get around that but the question is would we be loosing out on functionability and important features if we go that route. Is there any way around this problem or are we stuck in mud ?
0
Comment
Question by:ricazo
2 Comments
 
LVL 1

Accepted Solution

by:
lekshmikr earned 100 total points
ID: 1091592
SQL server accepts only your machine name as the server name .There is no other option but to rename ur machine name.

0
 

Author Comment

by:ricazo
ID: 1091593
Sorry, the reason why we have rename our server is because we are currently using a hyphen....
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trying to get a Linked Server to Oracle DB working 21 60
migration MS SQL database to Oracle 30 61
SSRS 2013 - Creating a summarized report 19 35
T-SQL:  Collapsing 9 25
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question