im creating a ecommerce website, and i need to create a database, im using visual studio .net
and when i try to create a new database using VS.net i choose "use sql server authentication" and no matter what i type in for the login id, i get the following ado error
"ADO Error : ' Login failed for user "blank". Reason. Not associated with a trusted SQL server connection.'
thanks in advance.
How can I create a new database on sql server using OSQL command incommand prompt. I have the sql file for database creation and I use thefollowing commandC:> osql -S servername -U sa -i db1.sqlit prompt my for password n i enter it since sa has a blank passwordbut after that it returns the following error.1> 2> 3> Msg 170, Level 15, State 1, Server servername, Procedure ,Line 2[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrectsyntax near 'COLLATE'.1> 2> 3> Msg 15010, Level 16, State 1, Server servername, Proceduresp_dboption, Line 95[Microsoft][ODBC SQL Server Driver][SQL Server]The database'db1' does not exist. Use sp_helpdb to show available databasesCan anyone help me on that?
View 3 Replies View RelatedHi,
I'm using Visual Studio 2008 and i guess the sql server comes with it is the 2005 express version. So, my problem is: when i try to create a new database diagram on a new .mdf database, i get the error "Invalid String Class".
I believe this has something to do with some unregistered dlls, but i dont know how to solve...
Any help?
I was getting following error while creating a database or attaching a database to sql server 2005
"The file <<*.mdf>> is compressed but does not reside in a read-only database or filegroup.."
In this scenario, if you try sp_attach_db procedure, you get following error:
Msg 5118, Level 16, State 1, Line 1
After
little bit of troubleshooting, I found this was happening because of a
folder option (of the folder where database file reside (in case of
attach) or being created (in case of create)).
Go to folder
properties, General Tab, click on Advanced button,check "Compress or
Encrypt attributes" section. If the first option (Compress contents to
save disk space) is checked, you get that error. Uncheck it to fix that
problem.
Hi there,
I am setting up a database for the first time using SQL Server Express.
I have managed to create a database and create a table with data etc, all straight forward.
The problem I am having is when I come to creating a user for the database. I have the following users in there already, which I am guessing are put in by default:
dbo
guest
INFORMATION_SCHEMA
sys
When I try creating a new user via this screen I get the following error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for User 'growstudiouser'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
'growstudio' is not a valid login or you do not have permission. (Microsoft SQL Server, Error: 15007)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15007&LinkId=20476
------------------------------
I was wondering if anybody could advise me as to what I'm doing wrong. I am typing in the name as "growstudiouser" and the login name as "growstudio".
Or am I just using the wrong section to do what I want. I'm trying to create a user so that when the database is built I can connect to it using a username and password that I have created. I'm not sure I'm taking to the correct route as there is no password option anywhere when creating a new user.
Thanks in advance,
Kevin
Hi
I created database using SQL server and runs under Cassini. The creation of database is ok but I have a problem when I am creating the table in database. Whenever I execute the code to create the tables, it shows the error message like 'Server not found' or just hang there. Does anybody know why it hang while I am creating the table? Is it because of the code or it's the time out error. Pls help as I am very new to this area.
MZ
Hi,
I was wondering if anyone might be able to help me out. I was trying to migrate access database to SQL Server 2005 Express Edition via Studio Express. I have also used SMAA for Access to migrate it to SQL Server 2005.
HOwever, i got trouble when creating new database in the studio Express. The following below is the error messages.
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'chw'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Could not obtain exclusive lock on database 'model'. Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807)
Could anyone help me how to get around this issue? I have no clue of what the error msg trying to say? what is database 'model'?
Thank you in advance
Hi,
I'm using VS2005, .NET Framework Version 2.0.50727 on Windows Vista Business.
I wish to implement a database in my mobile device which is using Windows CE 5.0, .NET Compact Framework 3.5 Beta, which version of SQL server should I install into the device?
I've tried using SQL mobile 2005 and SQL Server 2005 Compact Edition but it won't work. I'm having a Can't find PInvoke DLL 'sqlceme30.dll' error when I try to run the following block of code:
Code Block
private void button1_Click(object sender, EventArgs e)
{
SqlCeConnection sqlCeConnection = null;
MessageBox.Show("Entering try block");
try
{
if (!File.Exists(@"My DocumentsTest.sdf"))
{
SqlCeEngine sqlCeEngine = new SqlCeEngine(@"Data Source = My DocumentsTest.sdf");
sqlCeEngine.CreateDatabase();
MessageBox.Show("Create successful");
}
sqlCeConnection = new SqlCeConnection(@"Data Source = My DocumentsTest.sdf");
sqlCeConnection.Open();
MessageBox.Show("Open successful");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (sqlCeConnection != null)
sqlCeConnection.Close();
}
}
Can anyone please tell me how to solve this problem? Thanks in advance
Hello All,
I am trying to create a local database.............using a simple tool called BuildDatabase.cmd for example this is what i pass in the command prompt
C:My.databaseBuildDatabase SAMPLE1SQLEXPRESS MyTestDatabase
this is the error i am getting........
[SQL Native Client]SQL Network Interfaces: Error Locating Server/InstanceSpecified [xFFFFFFFF].[SQL Native Client]Login timeout expired[SQL Native Client]An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may be caused bythe fact that under the default settings SQL Server does not allow remoteconnections.
WARNING! Drop/Create Errors
can someone please help me out....how to fix this.
Thanks a lot
In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error:
"ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }"
It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors?). Is this the case?
Thank you.
I get an error dialog when I try to create a new SQL database, both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is:
Local Database File:
User does not have permission to perform this action.
I've searched for help with this.
I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder).
The SQL Server Express error log is clean and indicates full functionality.
Everything is running locally.
No VWD installation errors.
Any ideas?
Thank you!
Here is my code
ALTER PROCEDURE Test
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @From varchar(10)
DECLARE @To varchar(10)
DECLARE @DBName varchar
SELECT TOP 1 @From = CONVERT(char,CreateDate,101) FROM CustomerInfo
WHERE TicketNum =
(SELECT TOP 1 TicketNum FROM CustomerInfo
WHERE CreateDate <= DATEADD(mm, -30, CURRENT_TIMESTAMP)
ORDER BY CreateDate DESC)
SELECT @To = CONVERT(char,GETDATE(),101)
SET @DBName = 'Archive_SafeHelp'
CREATE DATABASE @DBName + ' ' + @From + ' ' + @To
END
I am trying to create a database based on the name contained in the variables. I get the error 'Incorrect syntax near '@DBName'. How do i accomplish this?
Thanks
Ganesh
Hi guys, can I know the steps on creating a database snapshot on a mirror database? Thx for the assistance. :)
Best Regards,
Hans
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
Following is the text of the error details:
TITLE: Microsoft Visual Studio
------------------------------
Error creating package
------------------------------
ADDITIONAL INFORMATION:
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
BUTTONS:
OK
------------------------------
I found a similar post that suggested that they try the following:
regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll
But msxml6.dll could not be found.
I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.
My concern now is what is the likelyhood of this being the only file missing from the installation.
I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.
Thanks.
Marshall
Hi:
I am trying to create a CLR UDF in SQL 2005 and cosnistently run into the following error. What am I doing wrong?. Please correct me and show me the right way of doing this.
Msg 6551, Level 16, State 2, Procedure EmailSplitter, Line 3
CREATE FUNCTION for "EmailSplitter" failed because T-SQL and CLR types for return value do not match.
Here is what I am trying to achieve. Split a Email field in the database. For that I am trying to return an array using C# and then trying to call the UDF for the C#.
--1).CLR Code. (EmailSpitter.cs)
using System;
using System.Collections.Generic;
using System.Text;
namespace SQLTools
{
public class EmailSplitter
{
public static string[] Parse(string data)
{
string[] columnData;
string[] separators = new string[1];
separators[0] = " ";
if (data != null)
{
columnData = data.Split(separators, StringSplitOptions.None);
return columnData;
}
return null;
}
}
}
--2). Assembly code.
CREATE Assembly SQLArrayBuilder
FROM 'E:CLREmailSplitterinDebugEmailSplitter.dll'
WITH PERMISSION_SET=SAFE
Select * from sys.assemblies.
--3). Create the function.
CREATE Function dbo.EmailSplitter
(@EmailString NVARCHAR(4000))
RETURNS VARCHAR(4000)
AS
EXTERNAL NAME SQLArrayBuilder.[SQLTools.EmailSplitter].Parse
Run into the error:
Msg 6551, Level 16, State 2, Procedure EmailSplitter, Line 3
CREATE FUNCTION for "EmailSplitter" failed because T-SQL and CLR types for return value do not match.
Please help me.
Thank you very much.
AK
This has got to be simple... Every time I try to create this sproc I get the following error:
Msg 156, Level 15, State 1, Procedure sp_AddTradeItemsToSelections, Line 5
Incorrect syntax near the keyword 'VIEW'.
Its driving me nuts because I can't see anything wrong with line 5 where the view is being created. CREATE PROCEDURE [dbo].[sp_XXXXX]
@UserdataIDInt,
@BuilderIDInt
AS
CREATE VIEW TradeItem_Append
AS
SELECT TradeItemID, UserDataID, BuilderID
FROM Selections
WHERE (UserDataID = @UserdataID)
SELECT TradeItem_Append.UserDataID, TradeItems.BuilderID, TradeItems.TradeID, TradeItems.TradeItem, TradeItems.Price, TradeItems.DDLRefNo,
TradeItems.TradeItemID, TradeItems.Details, TradeItems.ProductType, TradeItems.Room, TradeItems.Notes
FROM TradeItems LEFT OUTER JOIN
TradeItem_Append ON TradeItem_Append.TradeItemID = TradeItems.TradeItemID
WHERE (TradeItem_Append.TradeItemID IS NULL)AND(TradeItems.BuilderID = @BuilderID)
DROP VIEW TradeItem_Append
Hello All
im developing web application in VS2005(C#)
while Creating SQLDATASource for Gridview im getting Following error
cannot get web application service
Please help ME
Regards
Balagangadharan.R
Hi,
When I try to create a CLR function in SQL 2005 (June CTP) I get the following error:
Msg 6505, Level 16, State 1, Procedure Extenso, Line 1Could not find Type 'Extenso' in assembly 'ExtensoNET'.
The assembly registers successfully, with no errors.
I use the following command to create the function:CREATE FUNCTION Extenso (@Valor float)RETURNS VARCHAR(255)AS EXTERNAL NAME ExtensoNET.Extenso.EscreveExtensoGO
The function's code is the following:
using System;using System.Collections.Generic;using System.Text;using Microsoft.SqlServer.Server;using System.Data.SqlClient;
namespace ExtensoNET{ public class Extenso { [SqlFunction(DataAccess = DataAccessKind.Read)] public static string EscreveExtenso(double? nValor) {
//Valida Argumento if (nValor==null || nValor <= 0 || nValor > 999999999.99) return "";
//Variáveis int nTamanho; string cValor, cParte, cFinal; string[] aGrupo = { "", "", "", "", "" }; string[] aTexto = { "", "", "", "", "" }; . . . }
return cFinal;
} }}
Thanks in advance,
Anderson
Hi
I have a Win2K SP1 server running SQL 7. Whenever I try to create a DTS package, I get a box headed "DTS CoCreateInstance" with "Error in the DLL" as the box text. I have tried removing and re-installing SQL 7 and have also applied SQL SP 1,2 & 3. There are no errors in the event log, just the popup error outlined above.
Has anyone seen this error, and is there a fix?
Thanks
Simon Thomas
CommArc Consulting Ltd
Hi,
I don't see what's wrong with this command.
>>
Create View BCPOutBatchWeightTaiwan AS
Select *
from batchWeight a JOIN Geography b
ON a.GeographyPtr = b.GeographyPtr
where b.countrycode = 'tw'
<<
I get the following error if I try to create it.
>>
Server: Msg 4506, Level 16, State 1, Procedure BCPOutBatchWeightTaiwan, Line 2
Column names in each view must be unique. Column name 'GeographyPTR' in view 'BCPOutBatchWeightTaiwan' is specified more than once.
<<
But it runs fine if I run only th 'Select' part of the command
without 'CREATE' line.
Any help is appreciated.
Thanks.
Ranjit
I am trying to create an assembly on a sql server 2005 machine but it gives me following error:
Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.
I tried using the alter authorization statement to change the owner.
It did not work.
I am able to create same assembly on another test database but can not create it on this database.
Is this because of orphan logins?
Thanks for the help.
Harshal.
hi,
i want to create table using another table but i am getting the following error.
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.
my query is:
CREATE TABLE errorlog
AS SELECT * FROM log where 1=0
becos i a trying to copy the structure of the table log to table errorlog.please rectify my problem,please
We upgraded from SQL Server 2000 to 2005 recently. I'm attempting to create a credential for the first time and I keep getting the error shown below. Can anyone tell me what to do to resolve it? Thank You
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Credential 'schjob'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Credential&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An error occurred during decryption. (Microsoft SQL Server, Error: 15466)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15466&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
rm
I am trying to create an assembly on a sql server 2005 machine but it gives me following error:
Msg 33009, Level 16, State 2, Line 2
The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.
I tried using the alter authorization statement to change the owner.
It did not work.
The same assembly is created on another test database but can not create it on this database.
Is this because of orphan logins?
Thanks for the help.
Harshal.
What is wrong with the following command?
create database SuppliersDatabase
create table tblWarrantyClause(
WarrantyID int,
Warranty char(100),
WarrantyPeriod int,
Coverage char(100),
ReplacementPeriod int,
ReplacementPeriodUnit char(50),
DocRef char(100),
ReferencePage char(10),
ReferenceSection char(10),
ContractID_fk int );
I just wondering where can I find the table of my database SuplliersDatabase. I need to know if it is already exists or not? I tried to look around but then still I can't find it.
===============
JSC0624
===============
i tried running the statement :
(1)
create view qcostcentre
as
select * from dbo.costcentre.dtblcostcentre
>ERR: Msg 208, Level 16, State 1, Procedure qcostcentre, Line 4
Invalid object name 'dbo.costcentre.dtblcostcentre'.
(2)
create view qcostcentre
as
select * from costcentre.pcusers.dbo.dtblcostcentre
>ERR: Msg 7202, Level 11, State 2, Procedure qcostcentre, Line 4
Could not find server 'costcentre' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
note: pcusers is a user of 2 database (costcentre & datamaster) with dbo_datareader owned & role schema .
Hi guys
View 5 Replies View Related
Hi all,
When ever i tried to creat a diagram for the database i have i got this error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
the version of the database i am working in was backed up from another machine
what is the problem and how can i solve it?
Thanks in advance
On screen states [Error loading mining model metadata: No Metadata found]
and on the functions states [Error loading functions: no functions found]
This also occures when trying to use the Data mining wizard, it will just not respond.
Have deleted and removed all references to SQL2005 Standard and reloaded and still get same errors
Could someone please advise, have sent errors to Microsoft with no responce back yet.
I have a client who is getting an error when they try to create a report subscription. The error is as follows:
An unexpected error occurred: A subscription delivery error has occurred. ---> A subscription delivery error has occurred. ---> One of the extension parameters is not valid for the following reason: The account you are using does not have administrator priviledges. A subscription cannot be created for [email address].
The thing I find strange is that the client was able to create a shared schedule with no problems, so I don't see how they don't have administrator privileges. The shared schedules and subscriptions are created programmatically through a web application if that is of any importance.
Any ideas on how to fix this error?
I encountered something strange, deploying the following assemblies
CREATE ASSEMBLY [Sentry]
AUTHORIZATION [dbo]
FROM 'c:clrSentry.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS;
GO
CREATE ASSEMBLY [Sentry.XmlSerializers]
AUTHORIZATION [dbo]
FROM 'C:clrSentry.XmlSerializers.dll'
WITH PERMISSION_SET = SAFE;
GO
Sentry.XmlSerializers errored out with:
Msg 6218, Level 16, State 2, Line 2
CREATE ASSEMBLY for assembly 'Sentry.XmlSerializers' failed because assembly 'Sentry.XmlSerializers' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializerContract::CanSerialize][mdToken=0x600006e][offset 0x00000001][token 0x01000019]System.TypeLoadException: Could not load type 'Sentry.SentryDataService.SentryDataService' from assembly 'Sentry, Version=1.0.2764.18017, Culture=neutral, PublicKeyToken=null'. Type load failed.
The interesting thing is that when I deploy this locally on my machine, there are no problems whatsoever. Using sp_configure the servers appear to be set up the same way. The database also has trustworthy set on for both.
Anything, I could be missing? Thanks
Hi all, when I create publication with New Publication Wizard. I get the following errors. Did someone meet this before? Can you help me? Thanks!
===================================
SQL Server could not create publication 'JK'. (New Publication Wizard)
===================================
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(String sqlCommand)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()
at Microsoft.SqlServer.Replication.Publication.Create()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.CreatePublicationThreadMethod()
===================================
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
Changed database context to 'Test'. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3933&LinkId=20476
------------------------------
Server Name: nxstudio-davidsql2k5_dc
Error Number: 3933
Severity: 16
State: 1
Procedure: sp_addmergepublication
Line Number: 1034
------------------------------
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)
Hi,
I ran the script below fine in my Dev environment, bit it fails in production. Any ideas?
CREATE ENDPOINT SsbInitiatorEndpoint
STATE = STARTED
AS TCP (LISTENER_PORT = 5022)
FOR SERVICE_BROKER
(
AUTHENTICATION = WINDOWS
)
GO
CREATE MASTER KEY
ENCRYPTION BY PASSWORD = N'mypassword'
GO
CREATE CERTIFICATE SsbInitiatorCertificate
AUTHORIZATION SsbInitiatorUser
FROM FILE = N'D:SysapplMssql2005MSSQL$INSTANCENAMECertificatesSsbInitiator.cer'
WITH PRIVATE KEY
(
FILE = 'D:SysapplMssql2005MSSQL$INSTANCENAMECertificatesSsbInitiator.pvk',
DECRYPTION BY PASSWORD = 'mypassword'
)
GO
The error occurs on the CREATE CERTIFICATE statement:
Msg 15208, Level 16, State 1, Line 1
The certificate, asymmetric key, or private key file does not exist or has invalid format.
I am logged on as a local admin when running the script. The SQL Server service account is also a local admin, and the account I am logged on as is sysadmin in SQL Server. This script works fine in my Dev environment and a separate Pre-Prod environment.
I'm using SQL Server 2005 SP2.
Thanks,
Mark.