Sharepoint Server farm install

[bilbus]

I picked server farm install because i wanted to install sharepoint with SQL 2005. Everything is installed and i am at the config screen in sharepoint central administration. At the "set configuration database server" section i need to choose my server name and database name. I entered.

database server
DC2

SQL Server Database name
main

Database connection type
User windows auth

Active directory account creation
Users already have domain accounts

I hit "ok" to goto next page

And i get this error on next page

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code: 17).

It is windows 2003 STR, Sharepoint server (not portal)

SQL and sharepoint are on the same server.

Any ideas?
thanks

 

[Thomas2000]

Hello,

Have you made sure that the account you are running the sharepoint installation under has rights on the SQL to create new databases?

I have seen some information on the net about that WSS v2.0 will work with SQl 2005, but using it in production is not recommended, the next version of WSS v3 will be working with both SQL2005 and SQL2000.

I found this blog which might give you some more information about WSS v2 and SQL 2005

http://blogs.msdn.com/mikefitz/archive/2005/07/15/439489.aspx

What Servicepack level do you have on WSS? I think you need SP2 for WSS.

Let us know if you get it to work.

Regards,
Thomas

 

[Evilbart]

is your SQL2005 configured to allow remote connections?

//Bart

http://sharepointblogs.com/bart

 

[bilbus]

Thanks

I ended up just installing it the default way, and upgrading MSDE to sql 2000

thanks for the help though!