|
Creating Database error |
Post Reply ![]() |
Author | |
Asero23 ![]() MicrosoftDynamicsForums.com Member ![]() Joined: October 29 2009 Status: Offline Points: 47 |
![]() ![]() ![]() ![]() ![]() Posted: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
What credentials you are using when you connect to SL Database Maintenance?
|
|
![]() |
|
Asero23 ![]() MicrosoftDynamicsForums.com Member ![]() Joined: October 29 2009 Status: Offline Points: 47 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
thank you Rohtash
Yes im using sa to login ? |
|
![]() |
|
Asero23 ![]() MicrosoftDynamicsForums.com Member ![]() Joined: October 29 2009 Status: Offline Points: 47 |
![]() ![]() ![]() ![]() ![]() |
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 |