|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL server - cant see new backuped base
Hi all!
i got problem with one program which works on sql 2003 server. We backuped data from other base and created new base on other server. When we try to connect from client to that base - we cant see our new base in chose base menu. What can be wrong? Other bases works fine, we can see them. When you say "base" I assume you mean database, or DB.
If the files are moved to the new system, try to attach them. See sp_attach in BOL. Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a Windows server. Beyond that, we would need to know the version of SQL Server and how you backed up the databases and moved the files to the new server to be helpful. Show quoteHide quote "piwo" <taniep***@interia.pl> wrote in message news:fi48h4$rlj$1@nemesis.news.tpi.pl... > Hi all! > i got problem with one program which works on sql 2003 server. We backuped > data from other base and created new base on other server. When we try to > connect from client to that base - we cant see our new base in chose base > menu. What can be wrong? Other bases works fine, we can see them. > Oh ofcourse i mean DB when i say base:). Sql version is 2000 and its running
on windows server 2003. This is the way it was backuped: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ETMAC And i think this was the way of restoring it: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4JAE But when we try to connect from aplication to the new base, we cant see it. Other, old dbs we can see and work on it. What is BOL? Show quoteHide quote U¿ytkownik "Jay" <spam@nospam.org> napisa³ w wiadomo¶ci news:eUalecSLIHA.6008@TK2MSFTNGP05.phx.gbl... > When you say "base" I assume you mean database, or DB. > > If the files are moved to the new system, try to attach them. See > sp_attach in BOL. > > Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a Windows > server. > > Beyond that, we would need to know the version of SQL Server and how you > backed up the databases and moved the files to the new server to be > helpful. > > "piwo" <taniep***@interia.pl> wrote in message > news:fi48h4$rlj$1@nemesis.news.tpi.pl... >> Hi all! >> i got problem with one program which works on sql 2003 server. We >> backuped data from other base and created new base on other server. When >> we try to connect from client to that base - we cant see our new base in >> chose base menu. What can be wrong? Other bases works fine, we can see >> them. >> > > You may not be mapped your Login to that database?
-- Show quoteHide quoteEkrem Önsoy "piwo" <taniep***@interia.pl> wrote in message news:fi4ct2$8uh$1@nemesis.news.tpi.pl... > Oh ofcourse i mean DB when i say base:). Sql version is 2000 and its > running on windows server 2003. > This is the way it was backuped: > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ETMAC > > And i think this was the way of restoring it: > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4JAE > > But when we try to connect from aplication to the new base, we cant see > it. Other, old dbs we can see and work on it. > > What is BOL? > > U¿ytkownik "Jay" <spam@nospam.org> napisa³ w wiadomo¶ci > news:eUalecSLIHA.6008@TK2MSFTNGP05.phx.gbl... >> When you say "base" I assume you mean database, or DB. >> >> If the files are moved to the new system, try to attach them. See >> sp_attach in BOL. >> >> Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a Windows >> server. >> >> Beyond that, we would need to know the version of SQL Server and how you >> backed up the databases and moved the files to the new server to be >> helpful. >> >> "piwo" <taniep***@interia.pl> wrote in message >> news:fi48h4$rlj$1@nemesis.news.tpi.pl... >>> Hi all! >>> i got problem with one program which works on sql 2003 server. We >>> backuped data from other base and created new base on other server. When >>> we try to connect from client to that base - we cant see our new base in >>> chose base menu. What can be wrong? Other bases works fine, we can see >>> them. >>> >> >> > > You mean user account? How Can i check it?
Show quoteHide quote Uzytkownik "Ekrem Önsoy" <ek***@btegitim.com> napisal w wiadomosci news:E01B345F-6A3E-4BB1-8268-E9E0FE913406@microsoft.com... > You may not be mapped your Login to that database? > > -- > Ekrem Önsoy > > > > "piwo" <taniep***@interia.pl> wrote in message > news:fi4ct2$8uh$1@nemesis.news.tpi.pl... >> Oh ofcourse i mean DB when i say base:). Sql version is 2000 and its >> running on windows server 2003. >> This is the way it was backuped: >> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ETMAC >> >> And i think this was the way of restoring it: >> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4JAE >> >> But when we try to connect from aplication to the new base, we cant see >> it. Other, old dbs we can see and work on it. >> >> What is BOL? >> >> U¿ytkownik "Jay" <spam@nospam.org> napisa³ w wiadomo¶ci >> news:eUalecSLIHA.6008@TK2MSFTNGP05.phx.gbl... >>> When you say "base" I assume you mean database, or DB. >>> >>> If the files are moved to the new system, try to attach them. See >>> sp_attach in BOL. >>> >>> Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a Windows >>> server. >>> >>> Beyond that, we would need to know the version of SQL Server and how you >>> backed up the databases and moved the files to the new server to be >>> helpful. >>> >>> "piwo" <taniep***@interia.pl> wrote in message >>> news:fi48h4$rlj$1@nemesis.news.tpi.pl... >>>> Hi all! >>>> i got problem with one program which works on sql 2003 server. We >>>> backuped data from other base and created new base on other server. >>>> When we try to connect from client to that base - we cant see our new >>>> base in chose base menu. What can be wrong? Other bases works fine, we >>>> can see them. >>>> >>> >>> >> >> > We use Windows Authentication or SQL Authentication to login to SQL Server
Instances... And for this purpose there are Logins. Windows Logins are created from Windows Accounts. SQL Logins are created determining a Username and Password. These are Server Level principals. There are also Users in the databases. These are database level principals. You map\link Logins to Users to reach to the content of the databases. And the app you use to connect to your SQL Server instance has a Login too and that Login is mapped to some databases. As you restored a new database, that database may not be mapped to your Login which is used by your application. So your application can not connect to the new restored database. Open up Enterprise Manager. Connect to your SQL Server instance and then go to Security\Logins. Open your Login' s Properties and check out Database Access for that Login. If your Login is "sa" then it'll have all rights all around your SQL Server Instance. So you'd not need to map it to anything. -- Show quoteHide quoteEkrem Önsoy "piwo" <taniep***@interia.pl> wrote in message news:fi4moi$50o$1@atlantis.news.tpi.pl... > You mean user account? How Can i check it? > > Uzytkownik "Ekrem Önsoy" <ek***@btegitim.com> napisal w wiadomosci > news:E01B345F-6A3E-4BB1-8268-E9E0FE913406@microsoft.com... >> You may not be mapped your Login to that database? >> >> -- >> Ekrem Önsoy >> >> >> >> "piwo" <taniep***@interia.pl> wrote in message >> news:fi4ct2$8uh$1@nemesis.news.tpi.pl... >>> Oh ofcourse i mean DB when i say base:). Sql version is 2000 and its >>> running on windows server 2003. >>> This is the way it was backuped: >>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ETMAC >>> >>> And i think this was the way of restoring it: >>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4JAE >>> >>> But when we try to connect from aplication to the new base, we cant see >>> it. Other, old dbs we can see and work on it. >>> >>> What is BOL? >>> >>> U¿ytkownik "Jay" <spam@nospam.org> napisa³ w wiadomo¶ci >>> news:eUalecSLIHA.6008@TK2MSFTNGP05.phx.gbl... >>>> When you say "base" I assume you mean database, or DB. >>>> >>>> If the files are moved to the new system, try to attach them. See >>>> sp_attach in BOL. >>>> >>>> Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a >>>> Windows server. >>>> >>>> Beyond that, we would need to know the version of SQL Server and how >>>> you backed up the databases and moved the files to the new server to be >>>> helpful. >>>> >>>> "piwo" <taniep***@interia.pl> wrote in message >>>> news:fi48h4$rlj$1@nemesis.news.tpi.pl... >>>>> Hi all! >>>>> i got problem with one program which works on sql 2003 server. We >>>>> backuped data from other base and created new base on other server. >>>>> When we try to connect from client to that base - we cant see our new >>>>> base in chose base menu. What can be wrong? Other bases works fine, we >>>>> can see them. >>>>> >>>> >>>> >>> >>> >> > > Ok i think the problem resolved. Thanks to that step:
> Open up Enterprise Manager. Connect to your SQL Server instance and then go > to Security\Logins. Open your Login' s Properties and check Accounts of our aplication were created in Security\Logins and there were out Database > Access for that Login. other access rights in our new dbase and old dbase for that 2 accounts, created by software on sql server. When we changed it, dbs started to be visible from client side. THANKS VERY MUCH :) Show quoteHide quote Uzytkownik "Ekrem Önsoy" <ek***@btegitim.com> napisal w wiadomosci news:C9DF0D36-F470-414D-B1A0-5240F9BBE58E@microsoft.com... > We use Windows Authentication or SQL Authentication to login to SQL Server > Instances... And for this purpose there are Logins. Windows Logins are > created from Windows Accounts. SQL Logins are created determining a > Username and Password. These are Server Level principals. > > There are also Users in the databases. These are database level > principals. > > You map\link Logins to Users to reach to the content of the databases. > > And the app you use to connect to your SQL Server instance has a Login too > and that Login is mapped to some databases. > > As you restored a new database, that database may not be mapped to your > Login which is used by your application. So your application can not > connect to the new restored database. > > Open up Enterprise Manager. Connect to your SQL Server instance and then > go to Security\Logins. Open your Login' s Properties and check out > Database Access for that Login. > > If your Login is "sa" then it'll have all rights all around your SQL > Server Instance. So you'd not need to map it to anything. > > -- > Ekrem Önsoy > > > > "piwo" <taniep***@interia.pl> wrote in message > news:fi4moi$50o$1@atlantis.news.tpi.pl... >> You mean user account? How Can i check it? >> >> Uzytkownik "Ekrem Önsoy" <ek***@btegitim.com> napisal w wiadomosci >> news:E01B345F-6A3E-4BB1-8268-E9E0FE913406@microsoft.com... >>> You may not be mapped your Login to that database? >>> >>> -- >>> Ekrem Önsoy >>> >>> >>> >>> "piwo" <taniep***@interia.pl> wrote in message >>> news:fi4ct2$8uh$1@nemesis.news.tpi.pl... >>>> Oh ofcourse i mean DB when i say base:). Sql version is 2000 and its >>>> running on windows server 2003. >>>> This is the way it was backuped: >>>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ETMAC >>>> >>>> And i think this was the way of restoring it: >>>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4JAE >>>> >>>> But when we try to connect from aplication to the new base, we cant see >>>> it. Other, old dbs we can see and work on it. >>>> >>>> What is BOL? >>>> >>>> U¿ytkownik "Jay" <spam@nospam.org> napisa³ w wiadomo¶ci >>>> news:eUalecSLIHA.6008@TK2MSFTNGP05.phx.gbl... >>>>> When you say "base" I assume you mean database, or DB. >>>>> >>>>> If the files are moved to the new system, try to attach them. See >>>>> sp_attach in BOL. >>>>> >>>>> Also, SQL Server comes in 6.?, 7.0, 2000, 2005 & 2008. 2003 is a >>>>> Windows server. >>>>> >>>>> Beyond that, we would need to know the version of SQL Server and how >>>>> you backed up the databases and moved the files to the new server to >>>>> be helpful. >>>>> >>>>> "piwo" <taniep***@interia.pl> wrote in message >>>>> news:fi48h4$rlj$1@nemesis.news.tpi.pl... >>>>>> Hi all! >>>>>> i got problem with one program which works on sql 2003 server. We >>>>>> backuped data from other base and created new base on other server. >>>>>> When we try to connect from client to that base - we cant see our new >>>>>> base in chose base menu. What can be wrong? Other bases works fine, >>>>>> we can see them. >>>>>> >>>>> >>>>> >>>> >>>> >>> >> >> > You are welcome =)
-- Show quoteHide quoteEkrem Önsoy "piwo" <taniep***@interia.pl> wrote in message news:fi6a2l$lv1$1@nemesis.news.tpi.pl... > Ok i think the problem resolved. Thanks to that step: > > Open up Enterprise Manager. Connect to your SQL Server instance > and then go > > to Security\Logins. Open your Login' s Properties and check > out Database > > Access for that Login. > > Accounts of our aplication were created in Security\Logins and there were > other access rights in our new dbase and old dbase for that 2 accounts, > created by software on sql server. When we changed it, dbs started to be > visible from client side. THANKS VERY MUCH :)  
Other interesting topics
Optimizing and shrinking large highly-transactional database
Update Timeout and indexes Trigger to fire only after a commit. Regarding Transaction Log HT sp_help_jobschedule results? Is the same? Logging from SP Linked Server Properties - Security - SQL Server 2000 cannot drop mdf file sql server 2005 upgrade |
|||||||||||||||||||||||
