Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics SL (Solomon) > SL - Installation and Administration
  New Posts New Posts RSS Feed - Creating Database error
  FAQ FAQ  Forum Search   Register Register  Login Login


Creating Database error

 Post Reply Post Reply
Author
Message
Asero23 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 29 2009
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Asero23 Quote  Post ReplyReply Direct Link To This Post Topic: Creating Database error
    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


Back to Top
Sponsored Links


Back to Top
Rohtash Kapoor View Drop Down
MicrosoftDynamicsForums.com Moderator
MicrosoftDynamicsForums.com Moderator


Joined: July 06 2005
Location: United States
Status: Offline
Points: 655
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rohtash Kapoor Quote  Post ReplyReply Direct Link To This Post Posted: May 24 2010 at 9:25pm
Are you able to create any database directly in SQL Server Management Studio?
Back to Top
Asero23 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 29 2009
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Asero23 Quote  Post ReplyReply Direct Link To This Post Posted: May 24 2010 at 11:47pm
Yes it can even i manually connect to ODBC


Back to Top
Rohtash Kapoor View Drop Down
MicrosoftDynamicsForums.com Moderator
MicrosoftDynamicsForums.com Moderator


Joined: July 06 2005
Location: United States
Status: Offline
Points: 655
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rohtash Kapoor Quote  Post ReplyReply Direct Link To This Post Posted: May 24 2010 at 11:50pm
What credentials you are using when you connect to SL Database Maintenance?
Back to Top
Asero23 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 29 2009
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Asero23 Quote  Post ReplyReply Direct Link To This Post 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 ?

Back to Top
Rohtash Kapoor View Drop Down
MicrosoftDynamicsForums.com Moderator
MicrosoftDynamicsForums.com Moderator


Joined: July 06 2005
Location: United States
Status: Offline
Points: 655
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rohtash Kapoor Quote  Post ReplyReply Direct Link To This Post Posted: May 25 2010 at 12:33am

When you connect to SQL server in SL Database Maintenance, do you login as "sa"?

Back to Top
Asero23 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 29 2009
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Asero23 Quote  Post ReplyReply Direct Link To This Post Posted: May 25 2010 at 1:20am
thank you Rohtash

Yes im using sa to login ?
Back to Top
Asero23 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 29 2009
Status: Offline
Points: 47
Post Options Post Options   Thanks (0) Thanks(0)   Quote Asero23 Quote  Post ReplyReply Direct Link To This Post 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 .
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com