Installing fails at Step3 (and I followed the instructions!)

@Mohammad
SQL Server 2008 R2 is the version I have.

If you mean "correct data on conection string" when you say "correct instance", yes. I´m pretty sure because i tried it several times deleting database created and his login and doing it from the beginning.

What I´m doing (step by step):
- Open MS SQL Sever Manegement Studio v10.50.1600.1
- Right-click on 'Databases' and 'New database'
- Fill the fields whit (example) DB name 'cualquiera' and press OK
- Right-click on 'Security/New/Login' (not the 'cualquiera' database one) and fill it with:
On General page
· Login name: cualquiera
· SQL Server authentication (with no enforced pass policy)
· Put a password
· Default database: cualquiera
On Roles page
· Select the Sysadmin checkbox and save

That´s what I did several times for installing Orchard (in example) and it worked fine for me, but not at Kartris installation.

I´m a newbie on MS enviroments and it´s so possible I´m doing something wrong. I will be happy if some one can point my mistakes and offer som way to (at least) invetigate how to resolve.

UPDATE:
I reinstalled Kartris from the beginning (again) whit new database and login...

The data I provided is:
Server Name: (local)
Use Windows Authentication: unchecked
Username: cualquiera
Password: cualquiera
Use an existing database: checked
Create a new database: unchecked
Database Name: cualquiera

and results in:
Error: Connection failed to database. Error returned:Login failed for user 'cualquiera'.

Also, if I give it a wrong server name (for test the response) it says me that:
Error: Connection failed to database. Error returned:Error relacionado con la red o específico de la instancia mientras se establecía una conexión con el servidor SQL Server. No se encontró el servidor o éste no estaba accesible. Compruebe que el nombre de la instancia es correcto y que SQL Server está configurado para admitir conexiones remotas. (provider: Proveedor de canalizaciones con nombre, error: 40 - No se pudo abrir una conexión con SQL Server)

So I think server name instance is correct, at least it worked for Orchard...

Thanks to everybody for the time to respond me.

Author	Message
Hector	Posted Thu 13 Oct 2011
Supreme Being Group: Awaiting Activation Last Active: Mon 17 Oct 2011 Posts: 4, Visits: 17 3,086	Hi everybody at the forum! I´m having a problem installing Kartris at my local server; when I give it the database credentials it says me that 'Login failed for user 'XXX'' again and again every time I repeat the process. What I did: - I created a new database in my SQL Manager - I created a new login (with sysadmin role) - I choosed use an 'Existing database' - I double (or triple) check names and passwords - I tried (but nothing happens) instructions here: http://www.kartris.com/Knowledgebase/Error-CREATE-DATABASE-permission-denied-in-database-master__k-18.aspx Details: Windows Server 2008 IIS7.5 Kartris 1.3 Localhost but remote conecction Is the 6th time i tried everithing above and I´m stuck, may be I need some help... Anyone knows what I´m (possibly) forgoten? Any idea? Thanks in advance! PD: sorry for my english I now it´s terrible...
	REPLY QUOTE LIKE 391
thedrumdoctor	Posted Thu 13 Oct 2011
Supreme Being Group: Forum Members Last Active: Mon 21 May 2018 Posts: 94, Visits: 266 69,131	Is there any reason why you're choosing to install a database manually for Kartris to use? If you use the Microsoft Web Platform Installer it takes all the hard work away and creates a DB for you. I see you've stated "Localhost but remote connection". I had hell connecting remotely to the DB that the Kartris install process created when I tried to using the MS SQL 2008 Management tool until I followed this article. Seems you have to do a few tweaks to the default SQL 2008 install before you can remotely connect. Don't know if that will help.
	REPLY QUOTE LIKE 368
Hector	Posted Fri 14 Oct 2011
Supreme Being Group: Awaiting Activation Last Active: Mon 17 Oct 2011 Posts: 4, Visits: 17 3,086	@thedrumdoctor, thanks a lot for that quick response! The main reason for manual database setup is I tried first the automatic way that Kartris provide and doesn`t work. I installed other aplications (Orchard) with this method and it worked fine. I read the article you linked and all instructions are pointing to SQLEXPRESS2008. I was trying before to install on MSSQLSERVER with no luck. So, is SQLEXPRESS2008 a requeriment? Can I install Kartris on MSSQLSERVER? I tried both, following the instructions at the link you posted and nothing changes, I get the same error. Any else have an idea? Thanks for your time and regards.
	REPLY QUOTE LIKE 390
thedrumdoctor	Posted Fri 14 Oct 2011
Supreme Being Group: Forum Members Last Active: Mon 21 May 2018 Posts: 94, Visits: 266 69,131	I must say, I've never had the web installer fail installation, either locally or on shared hosting. If you've got the scope to do so in your setup, I'd look towards setting up a virtual server environment and going through the Kartris web-platform install procedure again on a vanilla guest O/S. The beauty of the installer is that it puts everything you need onto the server, including the right level of .NET, ISS & SQL. I'm currently using a virtual 2003 server within VMWare server 2 hosted on a 2003 box to develop under (I use 'develop' very loosely as I'm not a 'Developer'!) My virtual server with Kartris installed is only allocated 512Mb of RAM and it's enough to mess with. I don't think SQLExpress 2008 is a prerequisite for Kartris, it's just what the platform installer uses I suspect, because it's free. There's no reason why you can't use SQLExpress 2008 to develop on locally (though I believe it has a 4Gb DB limit) and throw it up to a web host with 'full-fat' SQL 2008. Troubleshooting on a server that's already had its SQL installation pre-configured by another installer could be a nightmare and you'd save more time developing within a virtual server environment, I reckon.
	REPLY QUOTE LIKE 404
Mohammad	Posted Fri 14 Oct 2011
Kartris Expert Group: Administrators Last Active: Sun 27 Sep 2015 Posts: 115, Visits: 706 79,533	Which version of sql server you have ? Can you confirm that you have written the correct instance for your sql server ?
	REPLY QUOTE LIKE 375
Paul	Posted Sat 15 Oct 2011
große Käse Group: Administrators Last Active: Tue 10 Sep 2024 Posts: 807, Visits: 2,748 513,776	It doesn't require SQL Express, any versions of SQL Server should be fine. We have customers running it on the web edition and other versions without any issues. We tend to use the express version only because it's free and that is what the majority of users will have access to. -- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future. If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb Tags sql server
	REPLY QUOTE LIKE 362
Hector	Posted Mon 17 Oct 2011
Supreme Being Group: Awaiting Activation Last Active: Mon 17 Oct 2011 Posts: 4, Visits: 17 3,086	@Mohammad SQL Server 2008 R2 is the version I have. If you mean "correct data on conection string" when you say "correct instance", yes. I´m pretty sure because i tried it several times deleting database created and his login and doing it from the beginning. What I´m doing (step by step): - Open MS SQL Sever Manegement Studio v10.50.1600.1 - Right-click on 'Databases' and 'New database' - Fill the fields whit (example) DB name 'cualquiera' and press OK - Right-click on 'Security/New/Login' (not the 'cualquiera' database one) and fill it with: On General page · Login name: cualquiera · SQL Server authentication (with no enforced pass policy) · Put a password · Default database: cualquiera On Roles page · Select the Sysadmin checkbox and save That´s what I did several times for installing Orchard (in example) and it worked fine for me, but not at Kartris installation. I´m a newbie on MS enviroments and it´s so possible I´m doing something wrong. I will be happy if some one can point my mistakes and offer som way to (at least) invetigate how to resolve. UPDATE: I reinstalled Kartris from the beginning (again) whit new database and login... The data I provided is: Server Name: (local) Use Windows Authentication: unchecked Username: cualquiera Password: cualquiera Use an existing database: checked Create a new database: unchecked Database Name: cualquiera and results in: Error: Connection failed to database. Error returned:Login failed for user 'cualquiera'. Also, if I give it a wrong server name (for test the response) it says me that: Error: Connection failed to database. Error returned:Error relacionado con la red o específico de la instancia mientras se establecía una conexión con el servidor SQL Server. No se encontró el servidor o éste no estaba accesible. Compruebe que el nombre de la instancia es correcto y que SQL Server está configurado para admitir conexiones remotas. (provider: Proveedor de canalizaciones con nombre, error: 40 - No se pudo abrir una conexión con SQL Server) So I think server name instance is correct, at least it worked for Orchard... Thanks to everybody for the time to respond me. Edited Mon 17 Oct 2011 by Hector
	REPLY QUOTE LIKE 390
Hector	Posted Mon 17 Oct 2011
Supreme Being Group: Awaiting Activation Last Active: Mon 17 Oct 2011 Posts: 4, Visits: 17 3,086	SOLVED!!! I found what I was doing incorrectly: SQL Server authentication was windows only!!! For everybody that could land at this post with the same problem: - Ensure you have mixed authentycation mode on your SQL Server: · Open the SQL Management Studio, right-click instance, properties\security & select the "SQL Server and Windows authentycation mode" - Also check that "Shared memory", "TCP/IP" and "Chanels" are enabled at your SQL Server Config Manager. - If aren´t, right-click it for enabling and restart the server. Hope this be useful for anyone. Thanks for the help and stimule for investigatigation!
	REPLY QUOTE LIKE 370

Installing fails at Step3 (and I followed the instructions!)

Installing fails at Step3 (and I followed the instructions!)

Similar Topics

Reading This Topic