SharePoint + SQL 2005

[biopatro]

Hi, I'm new on SharePoint, and I need to configure Sharepoint to work with SQL Server 2005 DB. Is it possible? I haven't found any documentation about this issue. Up to now I've followed the steps to configure Sharepoint with SQL Server 2000 but now I'm facing a problem that I'm not able to solve. I have to set the configuration server database. I've set the following data in the Sharepoint central administration form:
- server database: IP of the PC
- SQL Server database name: <MYNAME>
- Windows authentication
- users allready have an account in Active Directory
I'm logged as DOMAIN\Administrator and this user, (as far as I understand) has all permission on the the DB (even the database "master"). But when I try to configure the DB this error is returned "CREATE DATABASE permission denied in database 'master' (error code: 262). What can I do? Is it possible to use Sharepoint with SQL server 2005?
Any help will be appreciated.
Merry Christmas to all!
Andrea

 

[Evilbart]

This is perfectly possible.
Make sure your app pool account has the right permissions on your SQL 2005 server and your SQL server is allowed for remote connections ;-)

//Bart

//Bart

http://sharepointblogs.com/bart

 

[arlems]

I am using Sharepiont 2.0 and SQL 2000. Is there advantages to move to SQL 5.0 rather than staying with SQL 2000?

 

[Evilbart]

no special advantages (no new features unlocked or smth ;-)

But SQL2005 rocks ;-), Where we implemented SQL2005 the DB server was also used for some other purposes, CMS and some legacy apps. they seemed to benefit over SQL2000....


//Bart

http://sharepointblogs.com/bart

 

[arlems]

Thanks Evilbart,

I will take a look at SQL2005 for CMS purpose. Do you know by any chance if SQL2005 can replicate to an Oracle DB?

 

[Evilbart]

but yes it *should* be possible to replicate in some way (I'm no DBA) but reading through some files it can be done...

CMS on SQL2005 has no real benefits for CMS itself except the speed is fantastic ;-)


//Bart

http://sharepointblogs.com/bart

 

[arlems]

I took note, and will pass your message to the rest of my IT guys who haven't tried SQL2005 yet.