?
Solved

SQL Server naming issue

Posted on 1998-06-22
2
Medium Priority
?
192 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 200 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Here is how to restore SQL Server database to the point in time.  Follow the step by step approach to restore your database at a specific point in time and also understand its alternate approach.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

589 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