sql reports: utility

Showing posts with label utility. Show all posts

Tuesday, March 27, 2012

can we connect?

can we connect named instance through IP like in the network utility I just
defined the IP of the server where the named instance installed and define
the port...
Client Netowork Utility > Alias >
Alias: MyServer
Server: 209.45.23.55
Port : 1434
Protocol: TCP/IP
any thing else I need to do for connecting this... I did the above stuff but
I had failed to connect but why I can connect the default instance... please
guide me..
Thanks and I would highly appreciate if your prompt reply
thanks and have a great day
Hi,
Open the SQL Server error log under the folder
SQL_Server_installation_path>X\MSSQL$instance_name \LOG folder to make sure
that the SQL Server named instance runs well and to find the TCP port which
this named instance is listening.
As well as using Server network utility verify TCP/IP protocol is enabled.
Get the SQL Server name from Error log and use that name to connect from
query analyzer
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:DC15100C-5AC0-4C51-9CA3-8527DBF3DC23@.microsoft.com...
> can we connect named instance through IP like in the network utility I
> just
> defined the IP of the server where the named instance installed and define
> the port...
> Client Netowork Utility > Alias >
> Alias: MyServer
> Server: 209.45.23.55
> Port : 1434
> Protocol: TCP/IP
> any thing else I need to do for connecting this... I did the above stuff
> but
> I had failed to connect but why I can connect the default instance...
> please
> guide me..
> Thanks and I would highly appreciate if your prompt reply
> thanks and have a great day
>
|||First of all Hari, thanks for your reply... I can easily connect the named
instance on that same machine ... I am trying to connect that named instance
through my client machine and facing this problem...
"Hari Prasad" wrote:

> Hi,
> Open the SQL Server error log under the folder
> SQL_Server_installation_path>X\MSSQL$instance_nam e\LOG folder to make sure
> that the SQL Server named instance runs well and to find the TCP port which
> this named instance is listening.
> As well as using Server network utility verify TCP/IP protocol is enabled.
> Get the SQL Server name from Error log and use that name to connect from
> query analyzer
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:DC15100C-5AC0-4C51-9CA3-8527DBF3DC23@.microsoft.com...
>
>

Tuesday, March 20, 2012

Can this be done?

Is anyone aware of a utility, product or method to change a report definition at run-time? For example, I'd like to create a report and then perhaps remove columns, or change column order at run-time etc, based on user preference.

Thanks - Amos.

Out of the box you could use Report Builder to do this. There are some limitations in terms of layout and programmability, but it provides a very easy drag and drop experience for ad-hoc reporting.|||

John,

Thanks for the response. However, I am using the Report Viewer component to do strictly client side reporting using datasets. So, I don't think Report Builder will work, since, I think it only connects to a Report Services server (correct?).

Amos.

|||Yes, report builder requires the server.

Friday, February 24, 2012

Can somebody find where it fails, please?

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'PAC_APPS2' as 'PAC01\Administrator' (trusted)
Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
[1] Database IER: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER\IER_db_200705270200.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[2] Database IER: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 2 secs **
[3] Database MCI: Database Backup...
[4] Database SR_PAC: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\SR_PAC\SR_PAC_db_200705270200.BAK]
** Execution Time: 0 hrs, 0 mins, 2 secs **
[5] Database SR_PAC: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[6] Database Survey: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\Survey\Survey_db_200705270200.BAK]
** Execution Time: 0 hrs, 0 mins, 2 secs **
[7] Database Survey: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 2 secs **
[8] Database ServiceReq: Database Backup...
[9] Database whosnext: Database Backup...
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:34 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Hi Dave
"Dave" wrote:
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'PAC_APPS2' as 'PAC01\Administrator' (trusted)
> Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
> [1] Database IER: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER\IER_db_200705270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
> [2] Database IER: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [3] Database MCI: Database Backup...
> [4] Database SR_PAC: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\SR_PAC\SR_PAC_db_200705270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [5] Database SR_PAC: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [6] Database Survey: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\Survey\Survey_db_200705270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [7] Database Survey: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [8] Database ServiceReq: Database Backup...
> [9] Database whosnext: Database Backup...
> Deleting old text reports... 1 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:34 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
None of the steps seems to have failed, so it may be the job notifications
that are causing the problem! Have you checked the SQL Server Error Log for
any messages?
John|||Thanks, I will check that
-Dave
"John Bell" wrote:
> Hi Dave
> "Dave" wrote:
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'PAC_APPS2' as 'PAC01\Administrator' (trusted)
> > Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
> > [1] Database IER: Database Backup...
> > Destination:
> > [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER\IER_db_200705270200.BAK]
> >
> > ** Execution Time: 0 hrs, 0 mins, 3 secs **
> >
> > [2] Database IER: Verifying Backup...
> >
> > ** Execution Time: 0 hrs, 0 mins, 2 secs **
> >
> > [3] Database MCI: Database Backup...
> > [4] Database SR_PAC: Database Backup...
> > Destination:
> > [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\SR_PAC\SR_PAC_db_200705270200.BAK]
> >
> > ** Execution Time: 0 hrs, 0 mins, 2 secs **
> >
> > [5] Database SR_PAC: Verifying Backup...
> >
> > ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > [6] Database Survey: Database Backup...
> > Destination:
> > [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\Survey\Survey_db_200705270200.BAK]
> >
> > ** Execution Time: 0 hrs, 0 mins, 2 secs **
> >
> > [7] Database Survey: Verifying Backup...
> >
> > ** Execution Time: 0 hrs, 0 mins, 2 secs **
> >
> > [8] Database ServiceReq: Database Backup...
> > [9] Database whosnext: Database Backup...
> > Deleting old text reports... 1 file(s) deleted.
> >
> > End of maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:34 AM
> > SQLMAINT.EXE Process Exit Code: 1 (Failed)
> None of the steps seems to have failed, so it may be the job notifications
> that are causing the problem! Have you checked the SQL Server Error Log for
> any messages?
> John

Tuesday, March 27, 2012

can we connect?

Tuesday, March 20, 2012

Can this be done?

Friday, February 24, 2012

Can somebody find where it fails, please?

Can somebody find where it fails, please?

Can somebody find where it fails, please?

sql reports

Blog Archive

About Me