I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Management
Studio as trusted and SQL authentication.
Any ideas? Thanks!
Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
|||Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
|||ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
[vbcol=seagreen]
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
> "ricky252525" wrote:
Showing posts with label local. Show all posts
Showing posts with label local. Show all posts
Thursday, March 22, 2012
Error doing manual backup
I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Managemen
t
Studio as trusted and SQL authentication.
Any ideas? Thanks!Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
[vbcol=seagreen]
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
> "ricky252525" wrote:
>
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Managemen
t
Studio as trusted and SQL authentication.
Any ideas? Thanks!Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin a
nd
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Managem
ent
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
[vbcol=seagreen]
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
> "ricky252525" wrote:
>
Error doing manual backup
I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Management
Studio as trusted and SQL authentication.
Any ideas? Thanks!Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
> "ricky252525" wrote:
> > I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> > get an error trying to backup to a local drive:
> >
> > Cannot verify the existence of the backup file location.
> >
> > I read how this usually refers to backing up to a network share or
> > something, but this is a local drive. I tried it logged in to the Management
> > Studio as trusted and SQL authentication.
> >
> > Any ideas? Thanks!
get an error trying to backup to a local drive:
Cannot verify the existence of the backup file location.
I read how this usually refers to backing up to a network share or
something, but this is a local drive. I tried it logged in to the Management
Studio as trusted and SQL authentication.
Any ideas? Thanks!Hi
You may want to check backing up to a different directory, if that works it
must be ralated to the directory in which you are backing up to, such as
permissions.
John
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||Thanks, I tried that. Even tried to backup right to C, just for fun
--didn't work. Other suggestions?
"ricky252525" wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!|||ricky252525 wrote:
> I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> get an error trying to backup to a local drive:
> Cannot verify the existence of the backup file location.
> I read how this usually refers to backing up to a network share or
> something, but this is a local drive. I tried it logged in to the Management
> Studio as trusted and SQL authentication.
> Any ideas? Thanks!
Is the SQL Server service running as a domain user or as Local System?
Which domain user? What rights does that domain user have on the local
machine?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi
If you have checked/changed the service accounts as Tracy has suggested then
what message do you get if you back this up using a T-SQL script?
John
"ricky252525" wrote:
> Thanks, I tried that. Even tried to backup right to C, just for fun
> --didn't work. Other suggestions?
> "ricky252525" wrote:
> > I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and
> > get an error trying to backup to a local drive:
> >
> > Cannot verify the existence of the backup file location.
> >
> > I read how this usually refers to backing up to a network share or
> > something, but this is a local drive. I tried it logged in to the Management
> > Studio as trusted and SQL authentication.
> >
> > Any ideas? Thanks!
Wednesday, March 21, 2012
Error creating new SSIS project
In my local client installation of the BI tools, I get the following error when simply creating an SSIS project and the default empty Package tries to display on the screen.
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
I can use the Reporting Services designer with no problems, and I can use SSIS from the client tools on the server. It is just on my local PC that I get this error. I have completely uninstalled all the tools and reinstalled with no luck.
PLEASE HELP!
If anyone can help, please reply. I am unable to use SSIS AT ALL right now because a new package will only display this error message. And this is the purchased version, not the evaluation copy.
Here is the full message
Microsoft Visual Studio is unable to load this document:
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
I know it looks like I'm being a pest by bumping my post again, but I am not able to use SSIS at all on my PC. I HAVE TO get this resolved.
I am on Windows XP Pro fully patched and updated. I had SQL Express on my PC before and have since uninstalled it to see if that would help.
PLEASE HELP!!!
Friday, March 9, 2012
Error connecting to sql server 2005 express
Just manged to install sql server 2005 express after two days. I have a problem now! When i try to connect to it via my browser (local database), i get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have opened the surface area configuration manager and set the connections to remote and local but it still doesnt work
Any ideas would be great
Paul
I experienced the same problem when I tried to connect to the database via "Add new connection",but when I entered the path as localhost\sqlexpress, it worked. So you could try the same.
Hope that helps.|||
You are right. thanks a lot
Cheers
Error connecting to SQL Server 2005 - ... does not allow remote connections?
I have an ASP.NET 2.0 Website that in the connection string does not connect
to the local SQL Server but tries to connect to another SQL Server 2005
Server in another State. When I run the application from Visual Studio 2005
it connects just fine. When I published the website to the Live Server I
receive the below error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Any ideas?
Peace in Christ
Marco Napoli
http://www.ourlovingmother.orgCheck this url for troubleshooting:
http://blogs.msdn.com/sql_protocols.../22/506607.aspx
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Marco Napoli" <marco@.avantitecnospam.com> wrote in message
news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> I have an ASP.NET 2.0 Website that in the connection string does not
connect
> to the local SQL Server but tries to connect to another SQL Server 2005
> Server in another State. When I run the application from Visual Studio
2005
> it connects just fine. When I published the website to the Live Server I
> receive the below error:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> Any ideas?
> --
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>
>|||Thank you.
Marco
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:euqdnWInVNe2O8zZRVnyjg@.bt.com...
> Check this url for troubleshooting:
> http://blogs.msdn.com/sql_protocols.../22/506607.aspx
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
> "Marco Napoli" <marco@.avantitecnospam.com> wrote in message
> news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> connect
> 2005
>
to the local SQL Server but tries to connect to another SQL Server 2005
Server in another State. When I run the application from Visual Studio 2005
it connects just fine. When I published the website to the Live Server I
receive the below error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Any ideas?
Peace in Christ
Marco Napoli
http://www.ourlovingmother.orgCheck this url for troubleshooting:
http://blogs.msdn.com/sql_protocols.../22/506607.aspx
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Marco Napoli" <marco@.avantitecnospam.com> wrote in message
news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> I have an ASP.NET 2.0 Website that in the connection string does not
connect
> to the local SQL Server but tries to connect to another SQL Server 2005
> Server in another State. When I run the application from Visual Studio
2005
> it connects just fine. When I published the website to the Live Server I
> receive the below error:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> Any ideas?
> --
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>
>|||Thank you.
Marco
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:euqdnWInVNe2O8zZRVnyjg@.bt.com...
> Check this url for troubleshooting:
> http://blogs.msdn.com/sql_protocols.../22/506607.aspx
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
> "Marco Napoli" <marco@.avantitecnospam.com> wrote in message
> news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> connect
> 2005
>
Wednesday, March 7, 2012
Error connecting to remote SQL Server Analysis Services
Hi All,
I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.
I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-
"Cannot connect to <IP Address>
A Connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"
Things I have tried:-
- Ensured that the remote connection is enabled.
- Have SQL Server 2005 SP1 installed on the remote server.
- Tried installined SQL Server 2005 SP2 on my local machine, but same error.
I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.
Any kind of help will be appreciated on this.
Regards,
Sumeet:-)
We had similar problems when deploying cubes (although running Vanilla - not SP1)
We could replicate this problem by doing the following
1) Ensure all of the SQL Server Services (inc Analysis Services) are running
2) Browse a cube on your local machine
3) Rebuild this cube on your local machine
4) Check back on the remote server to see if AS is still running
If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following
"
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..
"
We found upgrading to SP2 stopped this issue
|||Hi,
Nice to see your reply.
The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.
Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...
Regards,
Sumeet
|||hi
did you check the security settings of the analysis server? (right click -> properties-> security)
add 'everyone' to it and try again for testing. i believe you should put your active directory user in it
for http connectivity, the default port number of analysis services is 2383
hope this helps
|||Hi Christina,
I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.
Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.
Regards,
Sumeet
|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work
good luck
|||
Hi Vali,
I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.
Later on I installed SP2 on my local machine and still I am getting the same error.
Regards,
Sumeet.
|||In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.
Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?
|||Hi John,
I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,
Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.
Regards,
Sumeet
|||Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.
Thanks in advance.
Sarah Cameron - Incycle Software
|||The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:
<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>
Hi Sarah,
We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.
So still waiting for help..
Regards,
Sumeet
|||Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.
__
Sarah Cameron - Incycle Software
Error connecting to remote SQL Server Analysis Services
Hi All,
I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.
I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-
"Cannot connect to <IP Address>
A Connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"
Things I have tried:-
- Ensured that the remote connection is enabled.
- Have SQL Server 2005 SP1 installed on the remote server.
- Tried installined SQL Server 2005 SP2 on my local machine, but same error.
I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.
Any kind of help will be appreciated on this.
Regards,
Sumeet:-)
We had similar problems when deploying cubes (although running Vanilla - not SP1)
We could replicate this problem by doing the following
1) Ensure all of the SQL Server Services (inc Analysis Services) are running
2) Browse a cube on your local machine
3) Rebuild this cube on your local machine
4) Check back on the remote server to see if AS is still running
If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following
"
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..
"
We found upgrading to SP2 stopped this issue
|||Hi,
Nice to see your reply.
The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.
Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...
Regards,
Sumeet
|||hi
did you check the security settings of the analysis server? (right click -> properties-> security)
add 'everyone' to it and try again for testing. i believe you should put your active directory user in it
for http connectivity, the default port number of analysis services is 2383
hope this helps
|||Hi Christina,
I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.
Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.
Regards,
Sumeet
|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work
good luck
|||
Hi Vali,
I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.
Later on I installed SP2 on my local machine and still I am getting the same error.
Regards,
Sumeet.
|||In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.
Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?
|||Hi John,
I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,
Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.
Regards,
Sumeet
|||Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.
Thanks in advance.
Sarah Cameron - Incycle Software
|||The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:
<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>
Hi Sarah,
We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.
So still waiting for help..
Regards,
Sumeet
|||Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.
__
Sarah Cameron - Incycle Software
Error connecting to remote SQL Server Analysis Services
Hi All,
I am trying to connect to the SQL Server Analysis Services on a remote server from my local machine, using SQL Server Management Studio.
I am able to connect to the SQL Server Database engine, but while connecting to the SQL Server Analysis services I get the following error :-
"Cannot connect to <IP Address>
A Connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connection host has failed to respond(System)"
Things I have tried:-
- Ensured that the remote connection is enabled.
- Have SQL Server 2005 SP1 installed on the remote server.
- Tried installined SQL Server 2005 SP2 on my local machine, but same error.
I think some issue with the ports might exists, Dont have an exact idea of how to check on with the port settings.
Any kind of help will be appreciated on this.
Regards,
Sumeet:-)
We had similar problems when deploying cubes (although running Vanilla - not SP1)
We could replicate this problem by doing the following
1) Ensure all of the SQL Server Services (inc Analysis Services) are running
2) Browse a cube on your local machine
3) Rebuild this cube on your local machine
4) Check back on the remote server to see if AS is still running
If your issue is the same as ours, AS will no longer be running and there will be errors in the Application event log which read the following
"
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\CubeTest.0.db\Data Warehouse.8.cub.xml is not a disk file or file is not accessible..
"
We found upgrading to SP2 stopped this issue
|||Hi,
Nice to see your reply.
The issue that I am actually facing is not related to the cube, since I am not able connect to the Analysis services from my local machine, so their's no chance for me to browse a cube.
Are you able to connect to the remote Analysis services using SQL Server management studio on your lcoal machine? I am not able to achieve this and getting the error here itself...
Regards,
Sumeet
|||hi
did you check the security settings of the analysis server? (right click -> properties-> security)
add 'everyone' to it and try again for testing. i believe you should put your active directory user in it
for http connectivity, the default port number of analysis services is 2383
hope this helps
|||Hi Christina,
I have checked with the security settings, and I have the active directory user added into it, also I tried adding 'everyone' to the list, but still I am getting the same error.
Regarding the port no, Can you please let me know where exactly we need to check with the port nos., since I havent made any changes to the port no of Analysis services.
Regards,
Sumeet
|||hi, i had the same problem on my local machine, where i was running sql server 2000 and sql2k service pack 3 installed. noone could browse my cubes. I read somewhere that when installing sp 3, it changes some user roles. i can give you a clue, i am not sure that it will work for you, but it worked for me:i have reinstalled Analysis services once again on another computer which was running win xp sp2. After that i installed sql2k sp 4, before, and not sql2k sp 3. This made it work
good luck
|||
Hi Vali,
I am using SQL Server 2005 on both my remote and local server, Also I have SP1 installed on both of my machines and it doesnt works.
Later on I installed SP2 on my local machine and still I am getting the same error.
Regards,
Sumeet.
|||In the SQL Server Surface Area Configuration tool the instance of Analysis Services might be set to Local Connections Only.
Can you even ping the remote machine from your local machine? Are you specifying a named instance when connecting?
|||Hi John,
I have Local and Remote Connections selected in the SQL Server Surface Area Configuration,
Also I am able to connect to the Database engine from my local machine to the Remote server using a SQL Server Authentication, but in Analysis services, theirs no option to login using SQL Server Authentication, and using Windows Authentication I am getting the above mentioned error.
Regards,
Sumeet
|||Have you resolved this issue? We are experiencing the same problem. We can connect to the Database Engine but are no longer able to connect remotely to the Analysis Services.
Thanks in advance.
Sarah Cameron - Incycle Software
|||The port setting for Analysis Service is configured in the 'msmdredir.ini' file that should be located in your '\Program Files\Microsoft SQL Server\90\Shared\ASConfig' directory. You should see a section at the bottom of the configuration settings for your specific instance with the name and the port number:
<Instances>
<Instance>
<Name>SQL2005</Name>
<Port>2194</Port>
</Instance>
</Instances>
Hi Sarah,
We actually are not yet able to find a fool proof solution for this, but found that it makes connection using the full doamin name. again this behavior is not consistent for each and every machine.
So still waiting for help..
Regards,
Sumeet
|||Thanks for the response. We were able to get our connection back yesterday evening. I think it had to do with some domain name resolution and active directory account authentication issues. The weird thing was that it was only affecting the Analysis Services and we were still able to connect to the Database Services. Sorry I can't be of more help in detailing why it is working again.
__
Sarah Cameron - Incycle Software
Error connecting to local SQL Server Express with SQL Server management Studio Express
I have SQL Server 2005 Express Edition installed on a Windows Server 2003 SP1 machine. I am trying to connect to the server on the local machine via shared memory with SQL Server Management Studio Express but I get the following error message:
TITLE: Connect to Server
Cannot connect to SERVER\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
I have already enabled remote connections, TCP Ports, etc., and disabled the firewall, but since I am connecting from a local machine, that should not matter. I have uninstalled and reinstalled SQL Server Express with same issue occuring. SQLServer service Browser service is running.
Can anyone share some ideas on how to troubleshoot this connection issue? Could this be caused by some scurity settings or services not running in Windows Server 2003? Any help would be greatly appreciated.
Seems to be a strange issue.
Please check whether the Engine Services are running by using the Configuration Manager. Also check whether the account with which the service is running has a valid login in the Server.
Regards,
Rajesh
|||After a good night sleep, I tried to connect to the database via Management Studio Express with the following Connection: .\SQLEXPRESS. This allowed me to connect to the database. Previously I had always connected with Server\SQLEXPRESS which produced the above error. After connecting to the datagase, the Registered Database window of Management Studio Express showed the database engine as server\sqlexpress, even though I could not connect to it using Server\SQLEXPRESS.
I felt happier I could connect, but I still couldn't understand why I can't connect using SERVER\SQLEXPRESS but have to use .\SQLEXPRESS. My real purpose of using SQL Server Express is to upgrade the back-end of an existing networked MS Access database application. When I went to SQL Server Configuration Manager to set up remote connections so I could connect from a client using a form of .\SQLEXPRESS or maybe IP ADDRESS/SQLEXPRESS, I noticed under SQL Native Client Configuration => Aliases, there was an alias configured for "SERVER\SQLEXPRESS". I don't know why this was there since I removed (via add/remove programs deleting the remaining Program Files => SQL SERVER directories) and reinstalled the application. I deleted this alias. After doing this I was able to connect to the Sever from Server Management Studio Express using SERVER\SQLEXPRESS. Finally I am able to progress to the task at hand of connecting to the database via Access Client, which leads to other problem I hope someone can help me with below.
In upsizing our Access application, we have decided only to upgrade the back-end but keep the front-end using Access and Jet connection to SQL Server via ODBC. We are currently using the "SQL Sever" ODBC driver that comes standard on Windows XP machine, configured at Administrative Tools => Data Sources (ODBC). I know this is not the best, but budget dictates (minimal to no changes in front-end Access) and it is a small application (~100MB size with one year of data). I am able to connect to the SQLEXPRESS database from ACCESS front-end at the client workstations, so I know the SQL SERVER Firewall settings are O.K. The problem I am having is that the connection drops out after 15 -30 minutes. I then can not reconnect to the database for some time. However, after additional amount of time, I am able to connect without changing anything in the configuration. We are using Windows Server 2003 R2 SP1 with Windows XP Pro clients. I don't think it is a network cabling problem because at the times when I can not connect to SQL SERVER, file and print sharing still work.
Does anybody have any hints on the easiest way to troubleshoot and fix this intermittant issue? Should I try to use the "SQL Native Client" ODBC Driver? Any suggestions are greatly appreciated.
|||Check any error or warning from SQL error logs & event viewer logs for the intermittent disconnection, also you can run a netmon trace to find where it is having problem. I guess as the clients can connect to SQL server now after your setup, its only on the network you should chekc.
Sunday, February 26, 2012
Error connecting new data source to SQL Server Express
In ODBC Data Source Administrator, I add the SQL Server driver, complete a name and select my local SQL Server instance, select Windows NT authentication (the client configuration is set to TCP/IP, dynamically determine port) and on clicking Next, the following errors occur:
Connection failed:
SQLState: '01000'
SQL Server error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory][ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
I note that in the Help it says: "The SQL Server system administrator must have associated your Microsoft Windows login with a SQL Server login ID".
Is this the problem? If so, where do I make this association?
Thanking you in anticipation.
In a default installation of SQL Express, every user on a computer can at least connect to the server. The fact that you're connection is failing suggests that something else is wrong. Based on the error, the most likely cause is that you've mis-typed the server name. SQL Express installs to a named instance so you need to provide both the machine name and instance name in your connection, be default, the instance name is SQLEXPRESS, so your server name would be <machinename>\SQLEXPRES. For local connection you can replace <machinename> with "(local)" or "." Note that it's a back slash, people commonly use the forward slash which will cause an error.
If that doesn't help, verify which SQL driver you are using, there are two of them. It looks like you're using the Native Client, which is good, but if you're using the old MDAC driver (just says "SQL Server" in the list) then you'll need to enable the TCP protocol for the Server using the SQL Configuration Manager. MDAC ODBC connection go through TCP, even for local connections.
Mike
|||Hi,
I would suggest to refer http://support.microsoft.com/kb/322336 & http://support.microsoft.com/kb/328306/en-us
Hemantgiri S. Goswami
Error connecting new data source to SQL Server Express
In ODBC Data Source Administrator, I add the SQL Server driver, complete a name and select my local SQL Server instance, select Windows NT authentication (the client configuration is set to TCP/IP, dynamically determine port) and on clicking Next, the following errors occur:
Connection failed:
SQLState: '01000'
SQL Server error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory][ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
I note that in the Help it says: "The SQL Server system administrator must have associated your Microsoft Windows login with a SQL Server login ID".
Is this the problem? If so, where do I make this association?
Thanking you in anticipation.
In a default installation of SQL Express, every user on a computer can at least connect to the server. The fact that you're connection is failing suggests that something else is wrong. Based on the error, the most likely cause is that you've mis-typed the server name. SQL Express installs to a named instance so you need to provide both the machine name and instance name in your connection, be default, the instance name is SQLEXPRESS, so your server name would be <machinename>\SQLEXPRES. For local connection you can replace <machinename> with "(local)" or "." Note that it's a back slash, people commonly use the forward slash which will cause an error.
If that doesn't help, verify which SQL driver you are using, there are two of them. It looks like you're using the Native Client, which is good, but if you're using the old MDAC driver (just says "SQL Server" in the list) then you'll need to enable the TCP protocol for the Server using the SQL Configuration Manager. MDAC ODBC connection go through TCP, even for local connections.
Mike
|||Hi,
I would suggest to refer http://support.microsoft.com/kb/322336 & http://support.microsoft.com/kb/328306/en-us
Hemantgiri S. Goswami
Error connectin to SQL 2005 Express
I've just installed Visual Studio 2005 and SQL Server 2005 Express beta 2
(all on my local PC). I try to connect to the SQL server from studio using
"Tools/Connect to database" selecting my local pc in the "Select or enter a
server name" combo box. I can select my pc's name but when I try to expand
the "Select or enter database name" combo or press the "Test connection"
button I get the following error:
"Shared memory provider: The specified module could not be found"
Any ideas?
Peter
http://www.aspfaq.com/sql2005/show.asp?id=3
Also, please use the SQL Server 2005 forums.
http://www.aspfaq.com/sql2005/show.asp?id=1
http://www.aspfaq.com/
(Reverse address to reply.)
"Peter Hemmingsen" <phe@.softco.dk> wrote in message
news:#YcDp4UpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> I've just installed Visual Studio 2005 and SQL Server 2005 Express beta 2
> (all on my local PC). I try to connect to the SQL server from studio using
> "Tools/Connect to database" selecting my local pc in the "Select or enter
a
> server name" combo box. I can select my pc's name but when I try to expand
> the "Select or enter database name" combo or press the "Test connection"
> button I get the following error:
> "Shared memory provider: The specified module could not be found"
> Any ideas?
> Peter
>
(all on my local PC). I try to connect to the SQL server from studio using
"Tools/Connect to database" selecting my local pc in the "Select or enter a
server name" combo box. I can select my pc's name but when I try to expand
the "Select or enter database name" combo or press the "Test connection"
button I get the following error:
"Shared memory provider: The specified module could not be found"
Any ideas?
Peter
http://www.aspfaq.com/sql2005/show.asp?id=3
Also, please use the SQL Server 2005 forums.
http://www.aspfaq.com/sql2005/show.asp?id=1
http://www.aspfaq.com/
(Reverse address to reply.)
"Peter Hemmingsen" <phe@.softco.dk> wrote in message
news:#YcDp4UpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> I've just installed Visual Studio 2005 and SQL Server 2005 Express beta 2
> (all on my local PC). I try to connect to the SQL server from studio using
> "Tools/Connect to database" selecting my local pc in the "Select or enter
a
> server name" combo box. I can select my pc's name but when I try to expand
> the "Select or enter database name" combo or press the "Test connection"
> button I get the following error:
> "Shared memory provider: The specified module could not be found"
> Any ideas?
> Peter
>
Sunday, February 19, 2012
Error between local development and production in a textbox
I have a textbox with the following:
=Fields!Distribution_Percentage.Value & "%"
It works fine on my local reportserver.
I deploy it to production and I get #Error instead.
I change it to
=Fields!Distribution_Percentage.Value
and it works fine on both except I want the % sign.
Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
result if I select the Percent format for the textbox, 100,000%.
Any clues what is happening?
NeilUse the custom format and put in 0% I think that would do it. I used 0
instead of # because I assume that if it is 0 you want to show 0% instead of
just %
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> I have a textbox with the following:
> =Fields!Distribution_Percentage.Value & "%"
> It works fine on my local reportserver.
> I deploy it to production and I get #Error instead.
> I change it to
> =Fields!Distribution_Percentage.Value
> and it works fine on both except I want the % sign.
> Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> result if I select the Percent format for the textbox, 100,000%.
> Any clues what is happening?
> Neil|||Thanks for replying but I didn't explain it well. At first I didn't have any
formatting specified. The # is part of the #Error displayed.
The real issue appears to be mixing field values.
In the header for this report, I have:
="From Fiscal " & Parameters!startdate.Value & " to " &
Parameters!enddate.Value
This also shows #Error on the prod server and shows the results expected
results locally. It sems to be complaining about mixing text and numeric
values.
The format for these textboxes is 'Default'. I wonder if there is some
configuration setting somewhere.
Thanks,
Neil
"Bruce L-C [MVP]" wrote:
> Use the custom format and put in 0% I think that would do it. I used 0
> instead of # because I assume that if it is 0 you want to show 0% instead of
> just %
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > I have a textbox with the following:
> > =Fields!Distribution_Percentage.Value & "%"
> > It works fine on my local reportserver.
> > I deploy it to production and I get #Error instead.
> > I change it to
> > =Fields!Distribution_Percentage.Value
> > and it works fine on both except I want the % sign.
> > Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> > result if I select the Percent format for the textbox, 100,000%.
> >
> > Any clues what is happening?
> > Neil
>
>|||This should be working for you. I do this all the time. As a matter of fact,
you should also have no problems with appending a % on too.
When doing a string like this you do not need any formatting specified.
Ahh, just thought of something. Report parameters are case sensitive. What I
do is use the expression builder when doing this sort of thing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:F810CF36-FF22-4679-BAB1-82E26D6DE67C@.microsoft.com...
> Thanks for replying but I didn't explain it well. At first I didn't have
any
> formatting specified. The # is part of the #Error displayed.
> The real issue appears to be mixing field values.
> In the header for this report, I have:
> ="From Fiscal " & Parameters!startdate.Value & " to " &
> Parameters!enddate.Value
> This also shows #Error on the prod server and shows the results expected
> results locally. It sems to be complaining about mixing text and numeric
> values.
> The format for these textboxes is 'Default'. I wonder if there is some
> configuration setting somewhere.
> Thanks,
> Neil
>
> "Bruce L-C [MVP]" wrote:
> > Use the custom format and put in 0% I think that would do it. I used 0
> > instead of # because I assume that if it is 0 you want to show 0%
instead of
> > just %
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> > news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > > I have a textbox with the following:
> > > =Fields!Distribution_Percentage.Value & "%"
> > > It works fine on my local reportserver.
> > > I deploy it to production and I get #Error instead.
> > > I change it to
> > > =Fields!Distribution_Percentage.Value
> > > and it works fine on both except I want the % sign.
> > > Since my numbers are like 100 or 25 instead of 1 or .25, I get the
wrong
> > > result if I select the Percent format for the textbox, 100,000%.
> > >
> > > Any clues what is happening?
> > > Neil
> >
> >
> >
=Fields!Distribution_Percentage.Value & "%"
It works fine on my local reportserver.
I deploy it to production and I get #Error instead.
I change it to
=Fields!Distribution_Percentage.Value
and it works fine on both except I want the % sign.
Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
result if I select the Percent format for the textbox, 100,000%.
Any clues what is happening?
NeilUse the custom format and put in 0% I think that would do it. I used 0
instead of # because I assume that if it is 0 you want to show 0% instead of
just %
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> I have a textbox with the following:
> =Fields!Distribution_Percentage.Value & "%"
> It works fine on my local reportserver.
> I deploy it to production and I get #Error instead.
> I change it to
> =Fields!Distribution_Percentage.Value
> and it works fine on both except I want the % sign.
> Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> result if I select the Percent format for the textbox, 100,000%.
> Any clues what is happening?
> Neil|||Thanks for replying but I didn't explain it well. At first I didn't have any
formatting specified. The # is part of the #Error displayed.
The real issue appears to be mixing field values.
In the header for this report, I have:
="From Fiscal " & Parameters!startdate.Value & " to " &
Parameters!enddate.Value
This also shows #Error on the prod server and shows the results expected
results locally. It sems to be complaining about mixing text and numeric
values.
The format for these textboxes is 'Default'. I wonder if there is some
configuration setting somewhere.
Thanks,
Neil
"Bruce L-C [MVP]" wrote:
> Use the custom format and put in 0% I think that would do it. I used 0
> instead of # because I assume that if it is 0 you want to show 0% instead of
> just %
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > I have a textbox with the following:
> > =Fields!Distribution_Percentage.Value & "%"
> > It works fine on my local reportserver.
> > I deploy it to production and I get #Error instead.
> > I change it to
> > =Fields!Distribution_Percentage.Value
> > and it works fine on both except I want the % sign.
> > Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> > result if I select the Percent format for the textbox, 100,000%.
> >
> > Any clues what is happening?
> > Neil
>
>|||This should be working for you. I do this all the time. As a matter of fact,
you should also have no problems with appending a % on too.
When doing a string like this you do not need any formatting specified.
Ahh, just thought of something. Report parameters are case sensitive. What I
do is use the expression builder when doing this sort of thing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:F810CF36-FF22-4679-BAB1-82E26D6DE67C@.microsoft.com...
> Thanks for replying but I didn't explain it well. At first I didn't have
any
> formatting specified. The # is part of the #Error displayed.
> The real issue appears to be mixing field values.
> In the header for this report, I have:
> ="From Fiscal " & Parameters!startdate.Value & " to " &
> Parameters!enddate.Value
> This also shows #Error on the prod server and shows the results expected
> results locally. It sems to be complaining about mixing text and numeric
> values.
> The format for these textboxes is 'Default'. I wonder if there is some
> configuration setting somewhere.
> Thanks,
> Neil
>
> "Bruce L-C [MVP]" wrote:
> > Use the custom format and put in 0% I think that would do it. I used 0
> > instead of # because I assume that if it is 0 you want to show 0%
instead of
> > just %
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> > news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > > I have a textbox with the following:
> > > =Fields!Distribution_Percentage.Value & "%"
> > > It works fine on my local reportserver.
> > > I deploy it to production and I get #Error instead.
> > > I change it to
> > > =Fields!Distribution_Percentage.Value
> > > and it works fine on both except I want the % sign.
> > > Since my numbers are like 100 or 25 instead of 1 or .25, I get the
wrong
> > > result if I select the Percent format for the textbox, 100,000%.
> > >
> > > Any clues what is happening?
> > > Neil
> >
> >
> >
Error Authentication User Informations
Hey Gang, I get a error message "Authentication Failed for SQL Server
instance: local with friendly name local SQL Server does not exist or
access denied". I have a Just loaded SQL Server on my virtual box and loaded
Microsofts bpa and microsoft security anlyzer. The security scan work but the
bpa scan does
not. I also look at the database,I can get access to and notice a new
database schema(sqlbpa). Any help would be appreciated.
instance: local with friendly name local SQL Server does not exist or
access denied". I have a Just loaded SQL Server on my virtual box and loaded
Microsofts bpa and microsoft security anlyzer. The security scan work but the
bpa scan does
not. I also look at the database,I can get access to and notice a new
database schema(sqlbpa). Any help would be appreciated.
Thanks
Garry DGarry D (garrydawkins@.hotmail.com) writes:
> Hey Gang, I get a error message "Authentication Failed for SQL Server
> instance: local with friendly name local SQL Server does not exist or
> access denied". I have a Just loaded SQL Server on my virtual box and
> loaded Microsofts bpa and microsoft security anlyzer. The security scan
> work but the bpa scan does not. I also look at the database,I can get
> access to and notice a new database schema(sqlbpa). Any help would be
> appreciated.
The message means that the specified SQL Server does not exist. (Or that
your network permissions prevented you from finding it).
If you have SQL Server running on your virtual box, and BPA running on your
host machine and have specified (local) as your SQL Server, that won't
fly. You need to specify the name of the virtual machine.
And, of course, you have to make sure that SQL Server is running.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, that work perfectly. By Identifying the server name within bpa
it took off and authenticated and is running as we speak.
GDawkins
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Wednesday, February 15, 2012
Error accessing report from anywhere but local server
I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "
After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."
Any help would be greatly appreciated!!
josh meyer
What does the Properties -> Security look like?|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
In Report Manager
1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||
Hi
It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).
Will certainly like to get soln to this problem
Error accessing report from anywhere but local server
I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "
After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."
Any help would be greatly appreciated!!
josh meyer
What does the Properties -> Security look like?|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
In Report Manager
1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||
Hi
It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).
Will certainly like to get soln to this problem
Error accessing report from anywhere but local server
I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "
After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."
Any help would be greatly appreciated!!
josh meyer
What does the Properties -> Security look like?|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:
In Report Manager
1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||
Hi
It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).
Will certainly like to get soln to this problem
Subscribe to:
Posts (Atom)