Sql Update command: studio

Showing posts with label studio. Show all posts

Friday, March 30, 2012

Problems installing SQL 2005 Express after trying VS.NET 2005 Beta 2

Hi Everyone,
I recently installed Visual Studio .NET 2005 Beta 2 which included SQL 2005 Community Technology Preview. After installing it all, I was no longer able to connect to my SQL 2000 instance in Enterprise Manager. The application opened ok but whenever I tried to browse the server or register it again, it was giving me an error relating to named pipes which really confused me since I was trying to connect to a SQL 2000 database through the SQL 2000 application. I was able to use the 2005 equivalent application (the name eludes me right now) to connect to the \SQLEXPRESS instance. All this time I could still connect to the default instance through Query Analyser and my .NET Web Applications that used SQL databases.
I later had to uninstall the betas because I needed a newer version of the .NET Framework to work with DotNetNuke 4.0. (A whole other story there...)
After uninstalling everything relating to the betas (which I had to do carefully in a prescribed order) I found that I couldn't even open Enterprise Manager properly. It had a big error message in the main display window. I discovered from a forum somewhere that I had to re-register a dll file to fix it. I did this and everything was back to normal.
(pause for breath)
OK, so then I downloaded Visual Web Developer 2005 Express Edition and installed it. Everything was great until the end of the SQL Server 2005 Express Edition setup when I was told it had failed to install. I haven't looked through ALL the log files but in the summary log file, the following message is reported for all three errors:
"[Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe."
I am running Windows XP, SP2 with everything up to date in Windows Update. The Beta 2 of VS.NET was the only beta software I've installed. I'm not trying to connect to a different machine or anything either. VS and SQL are both on the same machine. The only other thing that may be relevant is that the SQL 2000 I have is an evaulation version. I don't think that affects it but you never know. It's often the most overlooked variable that trips you.
Does anyone have any suggestions about how to remedy this?
Thanks for taking the time to read about my problem :)

i had the last ctp installed cleaned up the instalation and now when i try to install i get an error message:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe

walt

|||Sounds like an existing instance is there, but the service is not running.|||Walt,

Can you reply with the error code you're getting. Also, go to Add/Remove Programs and remove SQL Server Native Client and rerun setup and see if that works.

Dan|||

walt wrote:
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe
walt

That's exactly what's happening to me. I'm afraid I don't have a solution but you're the first person I've found who's got the same experience as me. I had Visual Studio 2005 Beta 2 including the SQL CTP and after I uninstalled it all I downloaded Visual Web Developer which included the SQL 2005 Express. I got the same error about no process on the other end of the pipe. (My post on the subject.)
Hopefully one of us will get a reply!|||

error code 29515 i did the add remove

thanks

|||Update:

I solved the problem by backing up my data and re-installing windows. I now have Visual Web Developer and SQL 2005 Express running alongside Visual Studio 2003 Enterprise Developer, MSDE and SQL 2000.

I don't know if there was a simpler solution but I had spent too much time on it already. Hurrah for my new Maxtor OneTouch II external 300GB beast that carried the burden of my data during these difficult hours!|||

Well, I can add myself to your group of installation problems with the same error mesage!!!

From my SQL Server Log:

Machine : <our machine name>
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--
Machine : <our machine name>

Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0012_MITTEN52_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: No process is on the other end of the pipe.
Error Number : 29515

Here's hoping someone comes up with a solution.

Problems installing SQL 2005 Express after trying VS.NET 2005 Beta 2

i had the last ctp installed cleaned up the instalation and now when i try to install i get an error message:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe

walt

|||Sounds like an existing instance is there, but the service is not running.|||Walt,

Can you reply with the error code you're getting. Also, go to Add/Remove Programs and remove SQL Server Native Client and rerun setup and see if that works.

Dan|||

walt wrote:
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe

walt

error code 29515 i did the add remove

thanks

|||Update:

Well, I can add myself to your group of installation problems with the same error mesage!!!

From my SQL Server Log:

Here's hoping someone comes up with a solution.

Wednesday, March 28, 2012

problems in Hands-On-Lab, MED302

Hi,

I am new to Windows Mobile. I am trying to follow the expample, MED302: Developing an SQL Mobile Application with Visual Studio 2005 and SQL Server 2005. The problem happend when I reached Exercise 4: Create a Subscription. After task 1 and 2, I typed http://yunan/sqlmobile/sqlcesa30.dll in IE. But I got "The page cannot be displayed" message and "HTTP 500 Internal server error". I am sure the IIS is running. Is there any other settings I need to do? If I continue to create subscription, I will get the following error message.

"
TITLE: Microsoft SQL Server Management Studio

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\ReplData\unc\YUNAN_SQLMOBILE_SQLMOBILE\20061018144997\CustomerData_2.sch' could not be propagated to the subscriber.
HRESULT 0x80070005 (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)
"
Many thanks in advance.

Yunan

Yunan,

Have you got this solved? I'm having the same error message and couldn't find a solution.

Eva

|||You must use a unc path, not c:\... but \\server\repldata. Look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1648231&SiteID=1|||

Hello,

Thank you very much for your reply. I am using \\server\\snapshot which is a unc path. This is a shared folder with Share Name as snapshot. It is physically under c:\\snapshot.

Any other suggestions?

Eva

|||Make sure access permissions are set properly for the share/file system folder, in order for the IIS merge agent to access the path.|||

Eric,

The permissions are set. The snapshot folder allows snapshotagent, internet agent account (IUSR_computer) to access. Those users also have access right (owner) to database and publication access list. Basically, I followed the steps in the following article:

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

I just can not create a subscription. I’ve exhausted the possible techniques I could find from forums. I don’t know if I need to re-install my existing software such as SQL server 2005, SQL 2005 CE (sqlcesa30.dll).

Thank you very much for your time. If you have new suggestions, please let me know.

Eva

|||

You can troubleshoot further and post your error stack, then it will be possible for other forum user to assist. Please enable SQL Server agent logging as per http://msdn2.microsoft.com/en-us/library/ms173017.aspx

|||

Eric,

Thanks again!

The problem was solved by move sqlcesa30.dll to my snapshot folder and modified my IIS virtue directory for SQLCE point to this folder. Now, I can move to next step of building applications.

Now, I continue to follow the sample in

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

When I try to do step 6 of Add a data connection, in the list of data providers, Microsoft SQL Server Compact Edition is not available. Any idea on how to add it?

Eva

|||

You must be using Visual Studio standard (or higher) SP1 for Microsoft SQL Server Compact Edition to be available.

problems in Hands-On-Lab, MED302

Hi,

"
TITLE: Microsoft SQL Server Management Studio

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

Yunan

Yunan,

Have you got this solved? I'm having the same error message and couldn't find a solution.

Eva

|||You must use a unc path, not c:\... but \\server\repldata. Look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1648231&SiteID=1|||

Hello,

Thank you very much for your reply. I am using \\server\\snapshot which is a unc path. This is a shared folder with Share Name as snapshot. It is physically under c:\\snapshot.

Any other suggestions?

Eva

|||Make sure access permissions are set properly for the share/file system folder, in order for the IIS merge agent to access the path.|||

Eric,

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

Thank you very much for your time. If you have new suggestions, please let me know.

Eva

|||

Eric,

Thanks again!

The problem was solved by move sqlcesa30.dll to my snapshot folder and modified my IIS virtue directory for SQLCE point to this folder. Now, I can move to next step of building applications.

Now, I continue to follow the sample in

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

When I try to do step 6 of Add a data connection, in the list of data providers, Microsoft SQL Server Compact Edition is not available. Any idea on how to add it?

Eva

|||

You must be using Visual Studio standard (or higher) SP1 for Microsoft SQL Server Compact Edition to be available.

Monday, March 26, 2012

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Hello
I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
If I go into the SQL Server Management Studio Express program in the Server
name dropdown there is nothing displayed - even if I browse. But database
should be local.
If I look in Services I don't see any SQL Server entry? The only thing
vaguely related I see in Services is SQL Server VSS Writer. And this has
started OK.
How can I troubleshoot this?
AngusHi Angus
"Angus" wrote:
> Hello
> I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
> If I go into the SQL Server Management Studio Express program in the Server
> name dropdown there is nothing displayed - even if I browse. But database
> should be local.
> If I look in Services I don't see any SQL Server entry? The only thing
> vaguely related I see in Services is SQL Server VSS Writer. And this has
> started OK.
> How can I troubleshoot this?
> Angus
>
What does it say as installed programs?
Do you have the installation log files see
http://msdn2.microsoft.com/en-us/library/ms143702.aspx ?
John

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Hello
I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run.
If I go into the SQL Server Management Studio Express program in the Server
name dropdown there is nothing displayed - even if I browse. But database
should be local.
If I look in Services I don't see any SQL Server entry? The only thing
vaguely related I see in Services is SQL Server VSS Writer. And this has
started OK.
How can I troubleshoot this?
AngusHi Angus
"Angus" wrote:

> Hello
> I have installed SQL Server 2005 on my XP Pro PC but I can't get it to run
.
> If I go into the SQL Server Management Studio Express program in the Serve
r
> name dropdown there is nothing displayed - even if I browse. But database
> should be local.
> If I look in Services I don't see any SQL Server entry? The only thing
> vaguely related I see in Services is SQL Server VSS Writer. And this has
> started OK.
> How can I troubleshoot this?
> Angus
>
What does it say as installed programs?
Do you have the installation log files see
http://msdn2.microsoft.com/en-us/library/ms143702.aspx ?
John

Problems getting information out of a SQLDataSource

I'm working in Visual Studio, I've added a SQLDataSource to the webpage which links to a SQL server database via a DSN (created with the wizard) and it brings back data from a stored procedure with no problems.

I want to access the information from this SQLDataSource in my code and can't seem to get anything from it.

help would be most appreciated.

What do you want to do with the data? Put it in a Gridview? Datalist? Here is a article with a GridView accessing a datasource.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/GridViewEx02.asp

|||I actually want to put the information into a text field rather than a datagrid.|||gave up on that and did it the easy way, all code rather than using the wizards.|||

How would you want to access the information from the SqlDataSource? If you just want to access the database retrieved from database by the Select command, you can do something like this:

SqlDataSource sds = new SqlDataSource(conn.ConnectionString, cmd.CommandText);

DataSourceSelectArguments dssa = new DataSourceSelectArguments();

dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);

DataView dv = (DataView)sds.Select(dssa);

problems during the deployment phase

I used the Business Intelligence Studio to make a report. I also enabled the tcp/ip protocol but during the deployment of the report i get the following error. I can see the report in Preview-Layout mode but i can t run the project. Could you help me

Thanks In Advance

===================================

A connection could not be made to the report server http://localhost/ReportServer$DVLP002_SQL2005/Reports. (Microsoft Report Designer)

===================================

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.Designer)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

It sounds like the specified ReportServerUrl is incorrect in your VS solution. You want to publish reports to the RS server web service - not to the RS report manager.

You should set the ReportServerUrl to: http://localhost/ReportServer$DVLP002_SQL2005

-- Robert

|||

Everything now is OK

Thank You Very Much

Nick Macis

problems downloading Microsoft SQL Server Management Studio Express

I everybody,

I'm trying to download Microsoft SQL Server Management Studio Express from

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

However, the download never finishs.

If I try to download using a download manager it stops after 98% (the segment that stops is the first segment).
If I try to download without a download manager it stops after 1% (456Kb).

What can I do?

Is there an alternate place where I can download the file?

Thanks,

Nadav

You're in the right place - try it from another network connection, and then copy the file to the first server. I just tested it and it downloads successfully from here.

Buck Woody

|||

Hi Buck,

I've managed to download it from another computer

(it was also several days later, so I don't know if the problem was related to the computer or if it was temporary).

Thanks anyway,

Nadav

|||

Good to hear. Let us know if we can be of any help.

Buck

problems downloading Microsoft SQL Server Management Studio Express

I everybody,

I'm trying to download Microsoft SQL Server Management Studio Express from

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

However, the download never finishs.

If I try to download using a download manager it stops after 98% (the segment that stops is the first segment).
If I try to download without a download manager it stops after 1% (456Kb).

What can I do?

Is there an alternate place where I can download the file?

Thanks,

Nadav

You're in the right place - try it from another network connection, and then copy the file to the first server. I just tested it and it downloads successfully from here.

Buck Woody

|||

Hi Buck,

I've managed to download it from another computer

(it was also several days later, so I don't know if the problem was related to the computer or if it was temporary).

Thanks anyway,

Nadav

|||

Good to hear. Let us know if we can be of any help.

Buck

Friday, March 23, 2012

Problems Creating Instance in SQL 2005 management studio

Hello all,

Thanks in advance for any help you can provide.

I am having a problem creating a new NS instance using SQL 2005 management

studio.

I am using the database element in my instance and application xml files like

this,

in order to create the NS application in an existing database.

<DatabaseName>%databasename%</DatabaseName>

<SchemaName>%schemaname%</SchemaName>

</Database>

the problem that I am having is that if I encounter an error somewhere in the

process of creating this new instance the instance name and schema name I

specified are still bound somewhere, and if I correct for the error and try to

create the instance again, I receive a new error saying that there is already

an instance with my instance name, or using the schema name.

If I try to list versions it tells me there are no instances, yet if I try to

add a new instance it tells me there is already an instance using my instance

name.

I have tried searching master database tables and views for anywhere

where it might be stored, also tried poking around most of management studio

and the registry, and just can not seem to find where it is remembering that I

had tried to create this instance before.

It is like it is partially creating the instance, running into an error, and

then not rolling back its changes somewhere.
Any help would be very much appreciated

-Derek-

Web Services

Integration Manager

TempWorks Software

Si Vis Pacem, Para Bellum.

"Those who profess to favor freedom, and yet depreciate agitation,

are men who want crops without plowing up the ground. They want rain without

thunder and lightning. They want the ocean without the awful roar of its

many waters. Power concedes nothing without demand. It never did and it

never will." - Frederick Douglass

additional error information.
I tried to remove the database and restore from a backup, and yet it still believe the instance name is in use.
I notice it seems to be checking the NS InstanceMetaData for existing instances on this server...
"Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.CheckInstanceNameInUse"
anyone know where this metadata is ?

===================================

The specified name is used by another Notification Services instance on the server. Specify a different instance name.
Instance Name: TWNSinstance
Server Name: derekxps (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=DuplicateInstanceName&LinkId=20476

Program Location:

at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.CheckInstanceNameInUse(SqlConnection sqlConnection, NSInstance instance)
at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.Add(NSInstance instance)
at Microsoft.SqlServer.NotificationServices.Common.NSDatabaseCreator.Create(NSDBState dbState, SqlDatabaseAttributes databaseAttributes, List`1 createdStates)
at Microsoft.SqlServer.NotificationServices.Common.InstanceCompiler.CreateDatabaseInfrastructure(Instance instance, NSSecureString argumentKey, NSInstance& nsInstance, Dictionary`2& nsApplications)
at Microsoft.SqlServer.NotificationServices.Common.InstanceCompiler.Create(Instance instance, NSSecureString argumentKey, Boolean uiReporting)
at Microsoft.SqlServer.NotificationServices.Common.InstanceCompiler.Create(NSSecureString sqlUserName, NSSecureString sqlPassword, String configFile, NSSecureString argumentKey, StringDictionary substitutions, Boolean uiReporting, String enforcedSqlServerSystem)
at Microsoft.SqlServer.Management.NotificationServicesUI.CreateInstanceGeneral.PerformCreate()|||

Hi Derek -

SQLNS 2005 stores its metadata in the MSDB database. Run this script in SSMS and see if your failed instance/application are listed.

USE MSDB

SELECT * FROM NS90.NSInstanceInfo

SELECT * FROM NS90.NSApplicationInfo

HTH..

Joe

|||Thanks Joe,
I did find the instance names and schema names that it had "eaten" in there. cleared them and was able to install with the instance name I wanted.
Thanks for your help!

-Derek-

Problems creating full-text population schedule via Management Studio

I am trying to schedule an hourly incremental update of the FT catalog on an indexed query. I have tried creating the catalog and schedule on both a remote machine (my workstation) and directly on the server. I get different errors on the two machines. I have tried creating the scheduled updates during the catalog creation process as well as seperately. I am able to create the catalog and update it manually in both cases. I cannot get the schedules created. The text of the errors are as follows:

NOTE: We run on an alternate port

From my workstation during the catalog creation process:

===================================

Create full-text population schedule failed.

===================================

Apply to target server failed for Job 'Start Incremental View Population on SyllabiDBI.qry_FTSearch'. (Microsoft.SqlServer.Smo)

For help, click:
removed

Program Location:

at Microsoft.SqlServer.Management.Smo.Agent.Job.ApplyToTargetServer(String serverName)
at Microsoft.SqlServer.Management.SqlManagerUI.FullTextIndexPopulationSchedule.ApplyIndexScheduleChanges(Server server, String databaseName, String tableName, String schemaName)
at Microsoft.SqlServer.Management.SqlManagerUI.FullTextIndexScheduleData.ApplyChanges(Server server, ServerConnection sqlConnInfo, FullTextIndexPopulationScheduleList scheduleList)
at Microsoft.SqlServer.Management.SqlManagerUI.FullTextWizardForm.PerformActions()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Agent.Job.ApplyToTargetServer(String serverName)

===================================

The specified @.server_name ('XXX.XXX.XXX.XXX,0000') does not exist. (.Net SqlClient Data Provider)

For help, click:
removed

Server Name: XXX.XXX.XXX.XXX,0000
Error Number: 14262
Severity: 16
State: 1
Procedure: sp_add_jobserver
Line Number: 88

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Upon recieveing that error, the catalog is created but contains no schedule population events. Trying to add the population job via the FT properties dialog results in the following (which is almost identical to the previous):

===================================

Cannot execute changes.

===================================

Apply to target server failed for Job 'Start Incremental Table Population on SyllabiDBI.qry_FTSearch'. (Microsoft.SqlServer.Smo)

For help, click:
removed

Program Location:

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

===================================

The specified @.server_name ('XXX.XXX.XXX.XXX,8081') does not exist. (.Net SqlClient Data Provider)

For help, click:
removed

Server Name: XXX.XXX.XXX.XXX,8081
Error Number: 14262
Severity: 16
State: 1
Procedure: sp_add_jobserver
Line Number: 88

Program Location:

If I immediately try to creat it again using the same method, it successfully creates the scheduled item and job but the job is malformed and will not run:

===================================

Start failed for Job 'Start Incremental Table Population on SyllabiDBI.qry_FTSearch'. (Microsoft.SqlServer.Smo)

For help, click:
removed

Program Location:

at Microsoft.SqlServer.Management.Smo.Agent.Job.Start()
at Microsoft.SqlServer.Management.SqlManagerUI.StartAgentJobs.StartJobAction.DoAction(ActionCollection actions, Int32 index)
at Microsoft.SqlServer.Management.SqlManagerUI.ActionCollection.DoWorkOnThread()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

===================================

Cannot start the job "Start Incremental Table Population on SyllabiDBI.qry_FTSearch" (ID 24C9505F-1388-46AD-AD4B-3024A8D3D154) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver. (.Net SqlClient Data Provider)

For help, click:
removed

Server Name: XXX.XXX.XXX.XXX,0000
Error Number: 14256
Severity: 16
State: 1
Procedure: sp_start_job
Line Number: 51

Program Location:

Now, on the server itself, I recieve the follwoing when trying to create the schedule via the initial catalog setup:

===================================

Create full-text population schedule failed.

===================================

Object reference not set to an instance of an object. (SqlManagerUI)

Program Location:

And then when trying to add the scheduled jobs:

===================================

Object reference not set to an instance of an object. (SqlManagerUI)

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.FullTextIndexPopulationSchedule.ApplyIndexScheduleChanges(Server server, String databaseName, String tableName, String schemaName)
at Microsoft.SqlServer.Management.SqlManagerUI.FullTextIndexScheduleData.ApplyChanges(Server server, ServerConnection sqlConnInfo, FullTextIndexPopulationScheduleList scheduleList)
at Microsoft.SqlServer.Management.SqlManagerUI.FullTextIndexPropertiesSchedule.OnRunNow(Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

Again, when I try to run the resulting job, they are malformed and result in the a similar error as to the one I posted above:

===================================

Start failed for Job 'Start Incremental View Population on SyllabiDBI.qry_FTSearch'. (Microsoft.SqlServer.Smo)

For help, click:
removed

Program Location:

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

===================================

SQLServerAgent Error: Request to run job Start Incremental View Population on SyllabiDBI.qry_FTSearch (from User XXX\Administrator) refused because the job has no job steps. (.Net SqlClient Data Provider)

For help, click:
removed

Server Name: XXX
Error Number: 22022
Severity: 16
State: 1

Program Location:

I believe it is a problem with the Management Studio IDE, but I can't be sure. So far, I have been unable to find another way to create the schedule or jobs. If I can create the jobs and schedule them via T-SQL I will happily do so.

Any insight is greatly appreciated.

I would like to know how you created this job, that is having this issue. It should work fine if you created under SQLAgent node.

Programatically you can use SMO objects (Look for JobServer in BOL)or agent SPs (look for sp_add_job and other related sps in BOL) to get this done

Thanks,

Gops Dwarak

sql

Problems creating a stored procedure in Management Studio

Hi,

I am probably going to sound really stupid but I have recently installed SQL Server Management Studio and been trying to figure out how to create a stored procedure in it. I have created a database called 'BTL_Dictionary' and that works fine. In the Object Explorer window when I click on the database, I get the tree view of all the different options. In order to write the stored procedure , I clicked on Programmability --> Stored Procedures --> New Stored Procedure.

This opened up the template and i made the following changes to the template :

-- =============================================

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author: blah

-- Create date:

-- Description: Adds the values into the DictionaryTable

-- =============================================

CREATE PROCEDURE [dbo].[AddDictionary]

-- Add the parameters for the stored procedure here

@.DictionaryID int ,

@.DictionaryName nvarchar(50),

@.DictionaryType nvarchar(50)

BEGIN

-- Insert statements for procedure here

INSERT INTO DictionaryTable

(

DictionaryID,

DictionaryName,

DictionaryType

)

VALUES

(

@.DictionaryID ,

@.DictionaryName ,

@.DictionaryType

)

END

-- =============================================

I saved the stored procedure, but when I refresh the database, I cannot see the stored procedure there. I trired re-opening the query and it indicates that the procedure belongs to the 'master' database instead of the 'BTL_Dictionary' database (its prefixed 'master.AddDictionary' instead of ''BTL_Dictionary.AddDictionary')

Can anyone tell me whats is is that I am doing wrong and how I can get rid of this .

Thanks

When you click "New Stored Procedure" MS will open a new query window with the PROC template in it. Just check that the database context is set to your database and not the master database. Or add a "USE" statement before the first statement in the template to ensure that the context is correct.

|||Thanks a lot for , that resolved the problem.

Problems connecting with VS.NET Server Explorer

I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!
I cannot help you but have a similar problem. I can add servers, but never
connect and see details. Worse yet, I cannot create a connection. I go
through the dialog and click test connection and get connection "test
connection succeeded" message. When I try to finish the task I get a message
twice saying "Unable to connect to database. The connection failed. Check
your username and password, and try again." Using either Enterprise Manager
or Query Analyzer, I can connect to the server and databases and see whatever
I need to.
I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
machine) and SQL Enterprise SP3 (different machine).
I am not sure when exactly this occurred as in the past I had created some
connections. I noticed it within the last couple weeks as I have gotten back
into .Net for my current project. I cannot use the old connections and once
deleted cannot recreate them as above.
"DBase_Tron" wrote:

> I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
> When I try to connect to my SQL Server from the VS.NET Server Explorer I can
> expand the server and look at the SQL Server instance on my computer but when
> I try to expand the instance, I get a login dialog entitled "SQL Server
> Login" which asks for Login and Password. When I put in what I think the
> Login and Password should be, it tells me, "The specified procedure could not
> be found". If I check the option that says, "Use Windows NT Integrated
> Security" it tells me "The specified procedure could not be found". I need
> some assistance from some gurus. What's going on here?!!
|||

Quote:

Originally posted by DBase_Tron
I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!

|||I have been searching news groups and Microsoft support sites for two days now and finally found a solution to our problem. You should download MDAC 2.8 and install. Apparently a new procedure has been included in this release. Good Luck.|||I had the same problem and what did to solve it was removing the Alias in
the SQL Server Client Network Utility, done.
Hope it helps
Javier.
"Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...[vbcol=seagreen]
>I cannot help you but have a similar problem. I can add servers, but never
> connect and see details. Worse yet, I cannot create a connection. I go
> through the dialog and click test connection and get connection "test
> connection succeeded" message. When I try to finish the task I get a
> message
> twice saying "Unable to connect to database. The connection failed. Check
> your username and password, and try again." Using either Enterprise
> Manager
> or Query Analyzer, I can connect to the server and databases and see
> whatever
> I need to.
> I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
> machine) and SQL Enterprise SP3 (different machine).
> I am not sure when exactly this occurred as in the past I had created some
> connections. I noticed it within the last couple weeks as I have gotten
> back
> into .Net for my current project. I cannot use the old connections and
> once
> deleted cannot recreate them as above.
>
> "DBase_Tron" wrote:
|||I looked there and I have no aliases.
"Javier Troconis" wrote:

> I had the same problem and what did to solve it was removing the Alias in
> the SQL Server Client Network Utility, done.
> Hope it helps
> Javier.
> "Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
> news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...
>
>

Wednesday, March 21, 2012

problems connecting to sql express 2005 server, where mdf file go?

Hello, I have correctly installed sql express 2005 onto my company server. I can connect to the sql express 2005 fine within sql management studio express. I can also connect to it the within visual studio 2005 server explorer. I have my database (MDF) on our server. I am trying to run my application within my client computer. I have changed the connection string property to connect to the server:

"Data Source=CTS\SQLEXPRESS;Initial Catalog=UpdateAttributes;Integrated Security=True"

My program will only work if there is a local copy of MDF database located within my application directory. If I remove the local copy, it errors "No process is on the other end of the pipe" Is it possible to have my application without the local copy of the MDF? I thought the idea is to have the MDF on the server. Then my app would not have the MDF copy!?Fixed the problem. Went to the server, changed the sql server 2005 surface area configuration under remote connections from using TCP/IP to TCP/IP and named pipes.

Problems connecting to server using Management Studio

Hi all,
I got this problem which makes me struggle in the last few days.
I am able to connect to my local server using a query analyzer or calling sql commands in a window application, but there's no way I can access it in Management Studio: by clicking "Connect" it just waits forever, and it doesn't respond to any other command (it must be shut by terminating the process)
Got any hints?

Thanks

Mauro

Try restarting the sql services may be your server is in hunged state......but i am not sure if that would solve the problem

|||Unfortunately, it doesn't do the trick... in fact, it's like Manag. Studio is able to connect to the server (I can see the list of databases in advanced options) but it doesn't show the result afterwards. Could it be a security/account problem?

Thanks

M|||Hi again,
just another hint trying to understand what's going on.
I just spent a couple of hours removing both the server and the client components and install it again, but the problems remains. Does configuration survive removal? Or should I look somewhere else?

Thanks

Mauro
|||From Management Studio are u trying to connect using Windows authentication or SQL authentication?
|||Both actually. And the result is the same connecting to a local or remote machine, that's why I am quite curious about this error (that in fact makes development harder... )

Mauro

Problems connecting to server using Management Studio

Thanks

Mauro

Try restarting the sql services may be your server is in hunged state......but i am not sure if that would solve the problem

Thanks

Mauro

problems connecting to remote SQL Server 2005

I'm using Visual Studio 2005 Pro and am attempting to connect to a remote SQL Server 2005. I have the server name, SQL login credentials, and database name. However, when I try connecting I get this 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 know that remote access is enabled because I received the connection instructions directly from the database administrator. I've tried turning off my firewall. I've tried connecting with Data source: Microsoft SQL Server using both Data providers: ".NET Framework Data Provider for SQL Server" and ".NET Framework Data Provider for OLE DB". Nothing seems to work.

Any suggestions for what I may be doing wrong? Do I have to have certain software installed on my computer to make this work (other that VS2005)?

-Mathminded

You have to configure SQL Server for remote connection and it is covered in the thread below, post again if you still need help. Hope this helps.

http://forums.asp.net/thread/1379211.aspx

|||

Thanks, Caddre. Just to clarify, I am trying to connect to a remote SQL Server 2005 that is maintained by someone else. They already have remote access enabled, but I haven't been able to connect to it. They have hundreds of users and the rest of them are connecting fine. Do I also have to enable remote access on my local SQL Express installation in order to connect to their server? It seems counterintuitive to me so I want to double-check before I spend several MORE hours trying to get this to work.

Thanks!

|||

I see your point but there are many reason for such problem so it takes time, I have found two troubleshooting links provided by Microsoft and another provided by another developer, run through the check list and post again if none works. Hope this helps.

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

http://blogs.msdn.com/sql_protocols/archive/2006/04/21/581035.aspx

http://geekswithblogs.net/timh/archive/2006/01/30/67586.aspx

|||

Thanks again, Caddre. I really appreciate your help. I've checked out all that information but it hasn't led me to a solution. I hate to give up an entire night of work, but I'm going to have to give up on this for now and try again tomorrow. If I come up with anything, I'll post it.

Thanks! :-)

|||If those did not work then it is either connection string or permissions you need to check back with them I hope you are not having this problem with Godaddy because users always run into problem with them. Hope this helps.|||

Problem solved! :-) It turns out they had never had a remote user have to access the SQL server from outside the company, so it was a firewall issue. They added my IP as an exception and it worked flawlessly. Thanks again, Caddre, for your willingness to help. I really appreciate it.

-Mathminded

|||

-Mathminded

|||

I am glad to see your problem was resolved but fire wall addressed in the protocol troubleshooting link I gave you.

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

|||

You're right, it was in those lists. That was one of the things I tried checking last night and one of the reasons I decided to give up. Unfortunately, there is no way (that I know of) to know with certainty that you are being blocked by a firewall. Last night I did try to ping and telnet to the server (two things from the links you provided) but when that didn't work it either meant they had disabled those functions OR I was being blocked by a firewall.

I'm glad you replied. I had marked the thread as resolved but hadn't remembered to mark your post as the answer. I don't know how the whole points thing works on this site, but if that's how people get points I wanted to make sure you got them.

Thanks again for all your help.

-Mathminded

|||Fire wall always block database and web server, it is the second thing to check after the configuration of the server and the points are not important to me anymore I have moved on from that subject, I always post again as needed so it will help future users with same problem.sql

Problems connecting to local SQL server [HELP!]

Hi all,

I have the developer edition of Visual Studio 2005. After successfully installing it in my local machine, I wanted to create a small application which connects to a database. I accessed the Server Explorer tool, right clicked on Data Connections and brought up the Create New SQL Server Database option.

The issue now is that I don't see a list of servers in the "Server Name" drop down box although in the Server Explorer itself, I have a server listed (your-c6b5e4eabc - The default computer name of my local machine).

I am given to believe that SQL server is unable to make a connection because I have not configured something which is essential.

I hope someone can point me as to how to make databases using SQL server and connect them to the application the way developers usually do. I'm a complete novice to VS 2005, and the SQL server configuration options have got me confused.

I'm not sure if this will help, but I'll include this here anyway :

When I tried copying and pasting the server name (your-c6b5e4eabc) into the "Server Name" drop down box and creating a database by entering a name in the "Enter database name" textbox, I get the following error message -

An error occured 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 Error : Could not open a connection to SQL Server.

I'm running Windows XP Media Center Edition v2002 SP 2.

I just want to be able to create and work with databases from within the applications I create in Visual Studio 2005. I played around with the configuration options (like enabling some protocols, the SQL server browser etc., but to no avail.) Is there a way to revert back to the default settings in an easy way? Thanks in advance for all your guidance...

Have a look in my screencasts section on my site showing you the way to enabled remote connections.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

Hey there,

Thanks very much for your screencast link. I think we should have more such user-friendly guides for first timers to Visual Studio. Unfortunately, I'm still facing the same problem creating a database from the Server Explorer.

I also have a rider question here : Although I've made a typical installation of Visual Studio 2005, the service I seem to be running isn't MSSQLSERVER, but rather SQLEXPRESS. I really need someone to throw more light on this aspect of Visual Studio 2005...or is my case an aberration?

Also, I mentioned playing around with the settings of the SQL Server 2005 Configuration Manager...can that be affecting things in any way? What are the ideal settings to connect to the server from within the server explorer in VS 2005? Most notably, I've set the SQL Server 2005 Services (SQLExoress and SQLBrowser) to log on as "NT Authority/LocalService"...is this the right setting?

Thanks again.

|||

Hi, thanks for the feedback, if you have any upcoming ideas about screencasts, feel free to contact me :-).

1.
SQL Server Express comes with VS 2005, you can use SQL Server Express at no charge. The SQL Server instances are reflected in the Service names, which are for a default instance MSSQLSERVER and for named Instances MSSQL$InstanceName. Named instances can be accessed by using the MachineName\InstanceName (and in addition if you don′t use the default port the ",portnumber" addition to the) name.

2.
Sure, changing the configuration will affect the current SQL Server instance (some changes might be reflected after the next reboot, like the remote connections setting). Local Services is fine if you don′t need any network ressources.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Tuesday, March 20, 2012

Problems after installing SP2

I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1).

When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog:

Errors in the OLAP storage engine: The linked measure group with the ID of 'Sales', Name of 'Sales' cannot be processed because it contains MG dimension with the ID of 'Time', Name of 'Time' with different granularity attribute than its source object.
Errors in the metadata manager. An error occurred when loading the Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.0.cub\Sales.1.det.xml'.
Errors in the metadata manager. An error occurred when loading the Trained Cube cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.1.cub.xml'.

At this point, there doesn't seem to be any way to open any database in BI Studio. I always get that error, even if I try typing in another database name.

SQL Management Studio seems slightly better - I can at least connect there. But it only shows a couple of the databases that were on the machine - a bunch are missing. Any attempt to process or browse any of the databases results in the same error as above.

Any ideas?

Quoting the SP2 Readme: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm

5.3.2 Analysis Services Databases that Contain a Linked Measure Group Might Become Unusable After Upgrade

Introduced in SQL Server 2005 SP2.

Analysis Services now requires that all dimensions contained in a linked measure group have the same granularity as the dimension in the source measure group. For example, if a time dimension in the source measure group has the day attribute as the granularity attribute, the linked measure group must also use the day attribute as the granularity attribute. The most common scenario for an Analysis Services database that violates this rule is a SQL Server 2000 Analysis Services database that was migrated by using a pre-release version of SQL Server 2005.

If you have a database that violates this granularity rule, you must modify the database containing the linked measure group before applying SP2. If you don't, the database will become invalid after SP2 is applied. Such invalid databases must be deleted.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks Edward. RTFM, eh? Actually, I doubt it would have helped - this is a sample DB that I found somewhere, I wouldn't have realized it had this issue.

The problem is, I don't see a way to delete the database. The admin tools all barf with that error when I try to do anything, including deleting a DB. Is there some other way to nuke it?|||Unless you can go back to pre-SP2 build, you can stop the service, and manually delete all the files and folders in the Data directory. Then you will have to redeploy and reprocess the rest of your databases, unless you have backups in which case you would simply restore them.|||Thanks Mosha. I deleted the .0.db directory and the 0.db.xml file for the bad database (which I didn't need anyway, it was just for playing with), and have now regained access to my server. Any other files I should delete to clean things up?|||

This should be enough.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've recently installed SP2. All was fine initially but I'm now getting the error listed above having not changed anything significant (changed the membersname unique property of an attribute and then changed it back again). I'd been making changes all day to the attribute relationships and deploying without a problem.

I'm not using a linked measure group but the measure group it's reporting an error on has a different granularity key to the main measure group. Apart from changing the granularity key of the group that has a problem what can I do to fix this?

Mark

|||

I got the same error message which is posted in the first post here.

On a server which didn't had the foodmart database installed, I didn't get any problems after installing SP2. When I tossed the foodmart files away as described above, all problems vanished. It seems the problem here is the foodmart database. At the end of it Im glad I got my DB back, but "they" managed to scare the living daylight out of me with this, because I thought the whole AS had been turned into a wreck. Ironically the only database left in the management studio was the foodmart db. If you don't use it I would recommend to delete it before installing SP2.

Regards, Jeroen

Friday, March 30, 2012

Problems installing SQL 2005 Express after trying VS.NET 2005 Beta 2

Problems installing SQL 2005 Express after trying VS.NET 2005 Beta 2

Wednesday, March 28, 2012

problems in Hands-On-Lab, MED302

problems in Hands-On-Lab, MED302

Monday, March 26, 2012

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Problems getting SQL Server 2005 Express to run on my XP Pro PC

Problems getting information out of a SQLDataSource

problems during the deployment phase

problems downloading Microsoft SQL Server Management Studio Express

problems downloading Microsoft SQL Server Management Studio Express

Friday, March 23, 2012

Problems Creating Instance in SQL 2005 management studio

Problems creating full-text population schedule via Management Studio

Problems creating a stored procedure in Management Studio

Problems connecting with VS.NET Server Explorer

Wednesday, March 21, 2012

problems connecting to sql express 2005 server, where mdf file go?

Problems connecting to server using Management Studio

Problems connecting to server using Management Studio

problems connecting to remote SQL Server 2005

Problems connecting to local SQL server [HELP!]

Tuesday, March 20, 2012

Problems after installing SP2

5.3.2 Analysis Services Databases that Contain a Linked Measure Group Might Become Unusable After Upgrade

Sql Update command

Blog Archive

About Me