|
|
Creating Database error |
Post Reply 
|
| Author | |
Asero23 
MicrosoftDynamicsForums.com Member 
Joined: October 29 2009 Status: Offline Points: 47 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Creating Database errorPosted: May 24 2010 at 2:39am |
|
Hi we are migrating to SL7 FP1 to service pack 3 and using SQL server 2008
but we were creating new database there is always an error here is the error: micrososoft ODBC sql server driver sqlserver could not find stored procedure 'master.dbo.xp_loginInfo' Please help anybody Thank you |
|
 |
|
| Sponsored Links | |
|
|
|
Rohtash Kapoor
MicrosoftDynamicsForums.com Moderator 
Joined: July 06 2005 Location: United States Status: Offline Points: 655 |
Post Options
Thanks(0)
Quote Reply
Posted: May 24 2010 at 9:25pm |
|
Are you able to create any database directly in SQL Server Management Studio?
|
|
|
|
|
Asero23
MicrosoftDynamicsForums.com Member
Joined: October 29 2009 Status: Offline Points: 47 |
Post Options
Thanks(0)
Quote Reply
Posted: May 24 2010 at 11:47pm |
|
Yes it can even i manually connect to ODBC
|
|
|
|
|
Rohtash Kapoor
MicrosoftDynamicsForums.com Moderator
Joined: July 06 2005 Location: United States Status: Offline Points: 655 |
Post Options
Thanks(0)
Quote Reply
Posted: May 24 2010 at 11:50pm |
|
What credentials you are using when you connect to SL Database Maintenance?
|
|
|
|
|
Asero23
MicrosoftDynamicsForums.com Member
Joined: October 29 2009 Status: Offline Points: 47 |
Post Options
Thanks(0)
Quote Reply
Posted: May 25 2010 at 12:02am |
|
i just follow the instructions from the installation guide when creating the empty databases
u think there is something to do with the service pack 3 ? |
|
|
|
|
Rohtash Kapoor
MicrosoftDynamicsForums.com Moderator
Joined: July 06 2005 Location: United States Status: Offline Points: 655 |
Post Options
Thanks(0)
Quote Reply
Posted: May 25 2010 at 12:33am |
|
When you connect to SQL server in SL Database Maintenance, do you login as "sa"? |
|
|
|
|
Asero23
MicrosoftDynamicsForums.com Member
Joined: October 29 2009 Status: Offline Points: 47 |
Post Options
Thanks(0)
Quote Reply
Posted: May 25 2010 at 1:20am |
|
thank you Rohtash
Yes im using sa to login ? |
|
|
|
|
Asero23
MicrosoftDynamicsForums.com Member
Joined: October 29 2009 Status: Offline Points: 47 |
Post Options
Thanks(0)
Quote Reply
Posted: May 25 2010 at 7:37pm |
|
we resolve the issue , we change the version of MS sql server 2008
the only glitch now is the collation issue . |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options