Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmanning
Starting Member
3 Posts |
 Posted - 2006-12-13 : 16:25:41
|
| First timer attempting transactional replication.I have been reading through tons of documentation. I just can't seem to get the type of answers I am looking for. Forums always seem to be the best way to get the help needed.The replication I am attempting seems to be much simpler than the documentation documents. I want to achieve replication on the same db server from one database_1 view to another database_2 table. That's it! The distributor, publisher, and subscriber all on one database server.When trying to set up the distributor; I get an error right away."Could not find object 'sp_MSrepl_startup' or you do not have permission."This got me looking into security and permissions at which point, I got scared. I felt like I was opening up our db servers to the world if I got any further.From the error message, I imagine I need a higher level of permissions to our db server? What do I need? What concerns should I have when setting up this type of replication? Would the wizard be sufficient enough to set up the needs I desire?Any insight or information would be warmly welcomed.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-13 : 16:40:54
|
| We replicate from one database to another on the same SQL instance without any problems. We do have the distributor on another server, but that's moot. What kind of permissions do you have on the SQL Server? Do you have a DBA there that can help you?Tara Kizer |
 |
|
|
bmanning
Starting Member
3 Posts |
Posted - 2006-12-13 : 16:51:35
|
| Funny you ask. We do not have a titled 'DBA'. This task is overflowed to the network guys. I would need to visit them. I believe I have sysadmin server roles. Everything I am working on at the moment is on a development environment in which I have free will to create tables, sp, views and etc. in the databases I have available to me. However, I do not even see the master database. So I assume I am limited.I was hoping to get what I was trying to achieve on dev before working with the network guys to accomplish the same thing on production. I wanted to have some knowledge prior.Do you make anything of the error message I get when trying to create configure distribution? Do you recommend the wizard to create replication in sql server 2005? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-13 : 17:21:41
|
| Yes I recommend the wizard to setup replication. That stored procedure exists in the master database. Since you can't see the master database, we need to find out if it's due to your Enterprise Manager configuration or a permission issue. Right click on the server in Enterprise Manager and go to Edit SQL Server Registration Properties. Is the box checked to Show system databases and system objects? If it's checked, then you don't have permissions, which means you also won't be able to setup replication. If the it's not checked, then check it and then see if that object exists in the master database (stored procedure section).Tara Kizer |
|
|
|
bmanning
Starting Member
3 Posts |
Posted - 2006-12-14 : 10:16:55
|
| I am using MS Server Management Studio. To see the master database; with db server selected, I went to Tools-Options. Under Environment-General, I unchecked 'Hide system objects in Object Explorer'.I am now able to see the Master database. I cannot find 'sp_MSrepl_startup'. However I can find 'sp_MSrepl_startup_internal'. What would be your take on that? Also, thank you for responding to my questions so far. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-14 : 13:18:42
|
| I just looked on one of our 2005 servers where we have replication configured and we don't have that stored procedure either, yet replication was setup and is working there. I've seen all sorts of missing object errors in replication 2005 though, but they didn't appear until after the snapshot was taken. I'd suggest calling MS about this issue.Tara Kizer |
|
|
|
|
|
|
|
|
sql server 2005 transactional replication