registering new sql server

Hello,
I have SQL server developer version running on my local workstation.
I recently got a new Win 2003 Box.
Couple of things.
1) IT dept gave me 35 gigs are raid 5. Is this enough for a large DB?
It seems awfully small to me.
2) The SQL server is running all well. In my local Enterprise Manger.
I tried to register a sql server. But I can't get a connect() back.
What could be causing this? I can ping the SQL box because it's on the
same subnet.
Won Lee> 1) IT dept gave me 35 gigs are raid 5. Is this enough for a large DB?
> It seems awfully small to me.
Depends on what you consider a large db. We've got a sql database just over
1 million records spread across 100 tables with that many views and stored
procedures besides, and that's 2gb.
> 2) The SQL server is running all well. In my local Enterprise Manger.
> I tried to register a sql server. But I can't get a connect() back.
> What could be causing this? I can ping the SQL box because it's on the
> same subnet.
Did you set up an alias in the Client Network Utility?|||> 1) IT dept gave me 35 gigs are raid 5. Is this enough for a large DB?
> It seems awfully small to me.
Only you can tell us how large your database is going to be. You need to
research your business requirements and determine size and growth from that.
There's no such thing as a "typical" size for a database.
> I tried to register a sql server. But I can't get a connect() back.
Can you give some more detail. Do you get an error message? Can you verify
in Service Manager that the server is running? Did you supply a valid user
name and password?
This might also help:
http://support.microsoft.com/?id=328306
David Portas
--
Please reply only to the newsgroup
--|||William Morris wrote:
>>1) IT dept gave me 35 gigs are raid 5. Is this enough for a large DB?
>>It seems awfully small to me.
>
> Depends on what you consider a large db. We've got a sql database just over
> 1 million records spread across 100 tables with that many views and stored
> procedures besides, and that's 2gb.
>
Thanks. I looked at the old DB and realized that we only grew at a 3
meg per month rate. I guess the DB is good for awhile.
>>2) The SQL server is running all well. In my local Enterprise Manger.
>>I tried to register a sql server. But I can't get a connect() back.
>>What could be causing this? I can ping the SQL box because it's on the
>>same subnet.
>
> Did you set up an alias in the Client Network Utility?
I didn't do anything. My IT guys set up the box. The error message I'm
getting is, WINBOX-SQL server does not exist or access denied.
I created a user as a DBO owner. I also tried with the SA login
credentials. I can remote desktop into the server and login to the SQL
server through Enterprise Manager and Query Analyzer.
I have no idea what Client Network Utility is so I looked it up in Books
Online. I will give that a try.
BTW How do I find out if they installed the Developer version or the
client/server version of SQL Server 2000?|||> Can you give some more detail. Do you get an error message? Can you verify
> in Service Manager that the server is running? Did you supply a valid user
> name and password?
> This might also help:
> http://support.microsoft.com/?id=328306
>
David,
Yes the service is started. I did created a user and also used the SA
password to login locally.
Thanks for the KB article I will look through it.|||> This might also help:
> http://support.microsoft.com/?id=328306
>
Just in case anyone is insterested.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306199
A link from the KB article David posted fixed the problem. Funny thing
is that the server is not on DHCP. It was when we first popped it in to
the rack but promptly changed it to a fixed IP address. Kinda funny.
But at least it works now.|||Thanks to William and David for helping me out.
Won Lee