Showing posts with label configured. Show all posts
Showing posts with label configured. Show all posts

Thursday, March 29, 2012

can't configure mirroring

Hi,
I've already configured a few databases from our server A to use mirroring
to our DR server. Now I've got a different primary server B and I am trying
to configure it so it mirrors to the same DR server. But I can't.
Is it supposed to work on the same port number as the first mirroring
connection between A & DR? or B & DR has to use a different port number? I've
also tried using a different port number (first check with netstat that it's
not used), but the Wizard doesn't allow me to enter a different port number
it still defaults to the same as between A & DR.
The error says that: The server network address "TCP://DR-server.local:5022"
can not be reached or does not exist. Check the network address name and that
the ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)
Any ideas? Thanks.
Panos.
I have the same problem. Three new servers setting up a mirror from a to b
with c as the witness. I have verified that I can connect to each from each
by going to a DOS prompt on each and executing "osql -Usa
-SserverDNSname,5022" It returns with an osql command prompt. I am using SQL
server 2005 Standard with SP2 on windows server 2003 sp1.
While going through the mirror setup wizard I get the error:
An error occurred while starting mirroring.
Additional information:
Alter fail for database 'test'. (Microsoft.sqlserver.smo)
An exception occurred while executing a transact-sql statement or batch.
(Micorosft.sqlserver.connectioninfo)
The server networkaddress "TCP://address.given.here.com:5022" can not be
reached or does not exists. Check the network address name and that the ports
for the local and remote endpoints are operational. (Microsoft sql server,
Error: 1418)
I did verify that the dsn names resolve. I used both integrated NT accounts
for authentication and the SQL Server sa account for setting up security
between all the servers and the same message results.
I used a port scanner and netstat to verify that 5022 is live.
It gets this message when it attempts to connect to the local host where
mirroring is being initiated from. There is no opportunity to put in
authentication information for the local host when setting up mirroring. I am
using an account that is in the administrators group on all three servers.
These servers are not part of a domain.
Seems to me there is a fundamental flaw with mirror setup.
Suggestions for further diagnosing this problem would be helpful.
|||Well mine is slightly different as the DR server (B) I am trying to make the
target has already been set-up successfully for mirroring with another server
(A). I am now trying to setup mirroring from Server C to server B but I get
the error message. Are you sure you can use mirroring with Developer edition?
I thought you need Enterprise but maybe that was before SP2. Check this
anyway.
Panos.
"DBA449" wrote:

> I have the same problem. Three new servers setting up a mirror from a to b
> with c as the witness. I have verified that I can connect to each from each
> by going to a DOS prompt on each and executing "osql -Usa
> -SserverDNSname,5022" It returns with an osql command prompt. I am using SQL
> server 2005 Standard with SP2 on windows server 2003 sp1.
> While going through the mirror setup wizard I get the error:
> An error occurred while starting mirroring.
> Additional information:
> Alter fail for database 'test'. (Microsoft.sqlserver.smo)
> An exception occurred while executing a transact-sql statement or batch.
> (Micorosft.sqlserver.connectioninfo)
> The server networkaddress "TCP://address.given.here.com:5022" can not be
> reached or does not exists. Check the network address name and that the ports
> for the local and remote endpoints are operational. (Microsoft sql server,
> Error: 1418)
> I did verify that the dsn names resolve. I used both integrated NT accounts
> for authentication and the SQL Server sa account for setting up security
> between all the servers and the same message results.
> I used a port scanner and netstat to verify that 5022 is live.
> It gets this message when it attempts to connect to the local host where
> mirroring is being initiated from. There is no opportunity to put in
> authentication information for the local host when setting up mirroring. I am
> using an account that is in the administrators group on all three servers.
> These servers are not part of a domain.
> Seems to me there is a fundamental flaw with mirror setup.
> Suggestions for further diagnosing this problem would be helpful.
|||Mirroring is now supported for SQL Server Standard edition 2005 with SP2
installed. I saw this on the Microsoft web site.
"Panos Stavroulis." wrote:
[vbcol=seagreen]
> Well mine is slightly different as the DR server (B) I am trying to make the
> target has already been set-up successfully for mirroring with another server
> (A). I am now trying to setup mirroring from Server C to server B but I get
> the error message. Are you sure you can use mirroring with Developer edition?
> I thought you need Enterprise but maybe that was before SP2. Check this
> anyway.
> Panos.
> "DBA449" wrote:
|||Microsoft?
I think we need a little help here?
What da ya sa...
"Panos Stavroulis." wrote:

> Hi,
> I've already configured a few databases from our server A to use mirroring
> to our DR server. Now I've got a different primary server B and I am trying
> to configure it so it mirrors to the same DR server. But I can't.
> Is it supposed to work on the same port number as the first mirroring
> connection between A & DR? or B & DR has to use a different port number? I've
> also tried using a different port number (first check with netstat that it's
> not used), but the Wizard doesn't allow me to enter a different port number
> it still defaults to the same as between A & DR.
>
> The error says that: The server network address "TCP://DR-server.local:5022"
> can not be reached or does not exist. Check the network address name and that
> the ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
> Any ideas? Thanks.
> Panos.
|||Solution found.
In my case the problem was that I had used the SQL Server Configuration
Manager to configure SQL Server to listen on port 5022. The documentation had
led me to believe that this had to be confgured manually when I couldn't
originally get it to work.
Apparently SQLServer will automatically set up that port to listen on when
mirroring is configured. If you set it up manually, it conflicts with the
automatic configuration.
I opened a case with Microsoft to resolve this issue, and they led me down a
path to configure SQLServer to run under a domain account. Previously I had
it configured to run as a local account in the administrators group. This
path led nowhere, the same error always resulted. Currently I have SQL server
to run under a local account that is part of the administrators group on all
three servers, principle, mirror and witness. And it seems to be functioning
fine.
Further, I was led to believe that you had to log in to the server using the
same account that SQL Server was running under in order to properly configure
SQLServer. This is not true either. I use one account to log into the server
for administrative purposes, and SQLServer runs under a different account.
"DBA449" wrote:
[vbcol=seagreen]
> Mirroring is now supported for SQL Server Standard edition 2005 with SP2
> installed. I saw this on the Microsoft web site.
> "Panos Stavroulis." wrote:
|||I had to revisit this!! The issue is resolved by creating a certificate on
the server, then linking it with the end point. Transferring the file to the
target, load and link with the other end point.
Panos.
"DBA449" wrote:
[vbcol=seagreen]
> Microsoft?
> I think we need a little help here?
> What da ya sa...
> "Panos Stavroulis." wrote:
|||that is what microsoft told me to do. But as indicated in the previous post,
it was not necessary
"Panos Stavroulis." wrote:
[vbcol=seagreen]
> I had to revisit this!! The issue is resolved by creating a certificate on
> the server, then linking it with the end point. Transferring the file to the
> target, load and link with the other end point.
> Panos.
> "DBA449" wrote:
sql

Sunday, March 25, 2012

can't attach 2 sample files can attach other files

I got SQL Server 2007 Express configured and I ran a few queries. It
appears to be configured correctly. I am trying to attach the
Northwind and Pubs example files from SQL Server 2000. I have tried
more than several times to attach them. I have them in the data file
of SQL Server 2007 express. The files are not read only. I looked
in the permissions and they were but I changed it to writeable and
checked the other files the log file and such.
When I try to attach the files I get the error message "Database
Northwind cannot be upgraded because it is read only or has read only
files. Make the files writeable and re-run recovery".
What is recovery? Do the files have to be upgraded from SQL SErver
2000?
thanks,Hi Janis,
Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
permissions of both data and log files?
You could also try this
Northwind and pubs Sample Databases for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Hope this helps,
Ben Nevarez
"Janis Rough" wrote:
> I got SQL Server 2007 Express configured and I ran a few queries. It
> appears to be configured correctly. I am trying to attach the
> Northwind and Pubs example files from SQL Server 2000. I have tried
> more than several times to attach them. I have them in the data file
> of SQL Server 2007 express. The files are not read only. I looked
> in the permissions and they were but I changed it to writeable and
> checked the other files the log file and such.
> When I try to attach the files I get the error message "Database
> Northwind cannot be upgraded because it is read only or has read only
> files. Make the files writeable and re-run recovery".
> What is recovery? Do the files have to be upgraded from SQL SErver
> 2000?
> thanks,
>|||On Jan 30, 7:10 pm, Ben Nevarez
<bneva...@.no.spam.please.sunamerica.com> wrote:
> Hi Janis,
> Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> permissions of both data and log files?
> You could also try this
> Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> Hope this helps,
> Ben Nevarez
> "Janis Rough" wrote:
> > I got SQL Server 2007 Express configured and I ran a few queries. It
> > appears to be configured correctly. I am trying to attach the
> > Northwind and Pubs example files from SQL Server 2000. I have tried
> > more than several times to attach them. I have them in the data file
> > of SQL Server 2007 express. The files are not read only. I looked
> > in the permissions and they were but I changed it to writeable and
> > checked the other files the log file and such.
> > When I try to attach the files I get the error message "Database
> > Northwind cannot be upgraded because it is read only or has read only
> > files. Make the files writeable and re-run recovery".
> > What is recovery? Do the files have to be upgraded from SQL SErver
> > 2000?
> > thanks,
sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
know the latest version was 2005, so that was helpful, however, I did
change the permissions for all the files, the log file and the mdf
files. They still won't attach.|||On Jan 31, 8:16=A0am, Janis Rough <jlro...@.yahoo.com> wrote:
> On Jan 30, 7:10 pm, Ben Nevarez
>
>
> <bneva...@.no.spam.please.sunamerica.com> wrote:
> > Hi Janis,
> > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed= the
> > permissions of both data and log files?
> > You could also try this
> > Northwind and pubs Sample Databases for SQL Server 2000http://www.micros=
oft.com/downloads/details.aspx?FamilyID=3D06616212-035...
> > Hope this helps,
> > Ben Nevarez
> > "Janis Rough" wrote:
> > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > appears to be configured correctly. =A0 I am trying to attach the
> > > Northwind and Pubs example files from SQL Server 2000. =A0 I have trie=d
> > > more than several times to attach them. =A0I have them in the data fil=e
> > > of SQL Server 2007 express. =A0 The files are not read only. =A0I look=ed
> > > in the permissions and they were but I changed it to writeable and
> > > checked the other files the log file and such.
> > > When I try to attach the files I get the error message "Database
> > > Northwind cannot be upgraded because it is read only or has read only
> > > files. Make the files writeable and re-run recovery".
> > > What is recovery? =A0Do the files have to be upgraded from SQL SErver
> > > 2000?
> > > thanks,
> sorry, it didn't help, I got the Northwind 2000 sample file. =A0I didn't
> know the latest version was 2005, so that was helpful, however, I did
> change the permissions for all the files, the log file and the mdf
> files. =A0They still won't attach.- Hide quoted text -
> - Show quoted text -
Hi Janis,
There is no need to attach the northwind or pubs dbs . There are
scripts like instnwnd.sql which will configure the northwind db for
you . Just execute the script.
and don't try to attach the db from higher version to lower
version...!
Thanks
Ajay|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
Thanks,|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
It worked I created Northwind and Pubs successfully. I have one
question if you happen to see this. Why don't the two databases now
show up in the Object Explorer?|||> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?
Did you refresh? Or even disconnect and re-connect?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Janis Rough" <jlrough@.yahoo.com> wrote in message
news:f4fc0c53-e93a-47ff-8a94-561e04fb773a@.h11g2000prf.googlegroups.com...
> On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
>> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>>
>> > On Jan 30, 7:10 pm, Ben Nevarez
>> > <bneva...@.no.spam.please.sunamerica.com> wrote:
>> > > Hi Janis,
>> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
>> > > permissions of both data and log files?
>> > > You could also try this
>> > > Northwind and pubs Sample Databases for SQL Server
>> > > 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
>> > > Hope this helps,
>> > > Ben Nevarez
>> > > "Janis Rough" wrote:
>> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
>> > > > appears to be configured correctly. I am trying to attach the
>> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
>> > > > more than several times to attach them. I have them in the data file
>> > > > of SQL Server 2007 express. The files are not read only. I looked
>> > > > in the permissions and they were but I changed it to writeable and
>> > > > checked the other files the log file and such.
>> > > > When I try to attach the files I get the error message "Database
>> > > > Northwind cannot be upgraded because it is read only or has read only
>> > > > files. Make the files writeable and re-run recovery".
>> > > > What is recovery? Do the files have to be upgraded from SQL SErver
>> > > > 2000?
>> > > > thanks,
>> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
>> > know the latest version was 2005, so that was helpful, however, I did
>> > change the permissions for all the files, the log file and the mdf
>> > files. They still won't attach.- Hide quoted text -
>> > - Show quoted text -
>> Hi Janis,
>> There is no need to attach the northwind or pubs dbs . There are
>> scripts like instnwnd.sql which will configure the northwind db for
>> you . Just execute the script.
>> and don't try to attach the db from higher version to lower
>> version...!
>> Thanks
>> Ajay
> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?sql

Monday, March 19, 2012

Cannot view reports, SSRS on Vista

Hello!
I have installed/configured SSRS on a Vista-laptop but I cannot view reports
in IE.
Finally, I got the reportserver running under IIS 7.0.The report works fine
in VS2005 and deployment (finally!!) works fine from the editor.
But the infamous 'rsReportNotReady'-error shows once I try to view a report.
Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
shows the reportServer root-directory. And the same thing happens if I
create a dumb .aspx-file and put into the reportServer/Pages directory.
The installation has been hellish so far, and I have read SO many blogs and
tips but nothing works...
* Yes, I have tried to turn off database snapshot isolation level for the
SSRS-databases
* Yes, I have installed Service Pack 2 (twice)
Im hoping for your help, as I see no path to a solution for this mystery!
Cheers DavidTwo things to try (I have never done this, this is from the newsgroup).
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
My advice is to try #1 first. I have seen this multiple times. As far as #2,
that I have only seen once in the newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I have installed/configured SSRS on a Vista-laptop but I cannot view
> reports in IE.
> Finally, I got the reportserver running under IIS 7.0.The report works
> fine in VS2005 and deployment (finally!!) works fine from the editor.
> But the infamous 'rsReportNotReady'-error shows once I try to view a
> report.
> Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> shows the reportServer root-directory. And the same thing happens if I
> create a dumb .aspx-file and put into the reportServer/Pages directory.
> The installation has been hellish so far, and I have read SO many blogs
> and tips but nothing works...
> * Yes, I have tried to turn off database snapshot isolation level for the
> SSRS-databases
> * Yes, I have installed Service Pack 2 (twice)
> Im hoping for your help, as I see no path to a solution for this mystery!
> Cheers David|||I managed to get thíngs running by un-installing the whole SQL-server package.
(I believe that I might have had a mix-up of editions installed)
Took me anothier full two hours, but now the thing works!
Thx for helping out!
David
"Bruce L-C [MVP]" wrote:
> Two things to try (I have never done this, this is from the newsgroup).
> 1) Control Panel / User Accounts / Turn User Account Control - off
> 2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
> My advice is to try #1 first. I have seen this multiple times. As far as #2,
> that I have only seen once in the newsgroup.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
> news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> > Hello!
> >
> > I have installed/configured SSRS on a Vista-laptop but I cannot view
> > reports in IE.
> >
> > Finally, I got the reportserver running under IIS 7.0.The report works
> > fine in VS2005 and deployment (finally!!) works fine from the editor.
> >
> > But the infamous 'rsReportNotReady'-error shows once I try to view a
> > report.
> >
> > Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> > shows the reportServer root-directory. And the same thing happens if I
> > create a dumb .aspx-file and put into the reportServer/Pages directory.
> >
> > The installation has been hellish so far, and I have read SO many blogs
> > and tips but nothing works...
> >
> > * Yes, I have tried to turn off database snapshot isolation level for the
> > SSRS-databases
> > * Yes, I have installed Service Pack 2 (twice)
> >
> > Im hoping for your help, as I see no path to a solution for this mystery!
> >
> > Cheers David
>
>

Thursday, February 16, 2012

Cannot see the SQL Express Instance on the Network Server list...

I have installed SQL Server Express and I can connect with it locally using "localcomputername\SQLEXPRESS". It is configured for remote connection and for some reason, when I browse for this instance on the Network Server, it does not appear in the list. I have unistalled/installed it several times and still I cannot see this instance on the SQL Network server list. Can anyone help troble shoot this frustrating issue...

Thanks!

SAM

hi Sam,

is the SQL Browser service up and running?

regards